|
1900
|
InsertControlItem / UserEditor / A2X:
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComBackColor to (RGB(240,240,240))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Variant voConditionalFormats
Get ComConditionalFormats to voConditionalFormats
Handle hoConditionalFormats
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats
Set pvComObject of hoConditionalFormats to voConditionalFormats
Variant voConditionalFormat
Get ComAdd of hoConditionalFormats "1 = 1" Nothing to voConditionalFormat
Handle hoConditionalFormat
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat
Set pvComObject of hoConditionalFormat to voConditionalFormat
Set ComBold of hoConditionalFormat to True
Send Destroy to hoConditionalFormat
Send Destroy to hoConditionalFormats
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Type" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComAlignment of hoColumn to OLERightAlignment
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "1. A ProgID such as "MSCAL.Calendar.7"" to h
Set ComItemDivider of hoItems h to 0
Variant hX
Get ComInsertControlItem of hoItems 0 "MSCAL.Calendar" "" to hX
Variant voCalendar
Get ComItemObject of hoItems hX to voCalendar
Handle hoCalendar
Get Create (RefClass(cComCalendar)) to hoCalendar
Set pvComObject of hoCalendar to voCalendar
Set ComBackColor of hoCalendar to (RGB(255,255,255))
Send Destroy to hoCalendar
Get ComAddItem of hoItems "2. A CLSID such as "{0036F83C-D892-4B7B-AA0B-BEDD8D16A738}"" to h
Set ComItemDivider of hoItems h to 0
Get ComInsertControlItem of hoItems 0 "{0036F83C-D892-4B7B-AA0B-BEDD8D16A738}" "" to hX
Get ComAddItem of hoItems "3. A URL such as "http://www.exontrol.com"" to h
Set ComItemDivider of hoItems h to 0
Get ComInsertControlItem of hoItems 0 "http://www.exontrol.com" "" to hX
Get ComAddItem of hoItems "4. A reference to an Active document such as "file://\\Documents\MyDoc.doc"" to h
Set ComItemDivider of hoItems h to 0
Get ComInsertControlItem of hoItems 0 "file://C:\empesting.xml" "" to hX
Get ComAddItem of hoItems "5.A fragment of HTML such as "MSHTML:<HTML><BODY>This is a line of text</BODY></HTML>"" to h
Set ComItemDivider of hoItems h to 0
Get ComInsertControlItem of hoItems 0 "MSHTML:<HTML><BODY>This is a <b>line of</b> text</BODY></HTML>" "" to hX
Set ComItemHeight of hoItems hX to 56
Get ComAddItem of hoItems "6.Anything, if it is preffixed by "A2X:"" to h
Set ComItemDivider of hoItems h to 0
Get ComInsertControlItem of hoItems 0 "A2X:TOC24.Toc24Ctrl.1" "" to hX
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1899
|
How do I add a RichTextBox editor
// Occurs when an user editor fires an event.
Procedure OnComUserEditorOleEvent Variant llObject Variant llEv Boolean llCloseEditor HITEM llItem Integer llColIndex
Forward Send OnComUserEditorOleEvent llObject llEv llCloseEditor llItem llColIndex
Showln llEv
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexAllLines
Set ComDefaultItemHeight to 32
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "RICHTEXT" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Variant voEditor
Get ComEditor of hoColumn to voEditor
Handle hoEditor
Get Create (RefClass(cComEditor)) to hoEditor
Set pvComObject of hoEditor to voEditor
Set ComEditType of hoEditor to OLEUserEditorType
Send ComUserEditor of hoEditor "RICHTEXT.RichtextCtrl" ""
Variant voRichTextBox
Get ComUserEditorObject of hoEditor to voRichTextBox
Handle hoRichTextBox
Get Create (RefClass(cComRichTextBox)) to hoRichTextBox
Set pvComObject of hoRichTextBox to voRichTextBox
Set ComAutoVerbMenu of hoRichTextBox to True
Set ComTextRTF of hoRichTextBox to "{\rtf1\ansi{\fonttbl\f0\fswiss Helvetica;}\f0\pard\r\nThis is some {\b bold} text.\par\r\n}"
Send Destroy to hoRichTextBox
Send Destroy to hoEditor
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems "RICHTEXT.RichtextCtrl" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1898
|
Is it possible to trap a double-click event on a specific cell and when that happens, to set the cell to a specific value
// Occurs when the user dblclk the left mouse button over an object.
Procedure OnComDblClick Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComDblClick llShift llX llY
Variant h
Get ComItemFromPoint -1 -1 c hit to h
Variant v
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComCellValue of hoItems h c to v
Send Destroy to hoItems
Showln v
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComHeaderAppearance to OLEEtched
Set ComDrawGridLines to OLEexRowLines
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "C1" to Nothing
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Get ComAdd of hoColumns1 "C2" to Nothing
Send Destroy to hoColumns1
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Set ComCellValue of hoItems1 (ComAddItem(hoItems1,"Item 1")) 1 to "Item 2"
Set ComCellValue of hoItems1 (ComAddItem(hoItems1,"Item 3")) 1 to "Item 4"
Set ComCellValue of hoItems1 (ComAddItem(hoItems1,"Item 5")) 1 to "Item 6"
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1897
|
How can I display dates in DD/MM/YYYY format
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to False
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Date" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComItemDivider of hoItems (ComAddItem(hoItems,"Different Date Formats")) to 0
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "((shortdateF(value) mid 4) left 2) + `/` + (shortdateF (value) left 2) + `/` + (shortdateF (value) right 4)"
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "(1 array (0:=(shortdateF(value) split `/`))) + `/` + (0 array (=:0) ) + `/` + (2 array (=:0) )"
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "((`0` + day(value) ) right 2) + `/` + ((`0` + month(value) ) right 2) + `/` + year(value)"
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "day(value) + `/` + month(value) + `/` + year(value)"
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "year(value) + ` - ` + day(value) + ` - ` + month(value)"
Variant h
Get ComAddItem of hoItems "12/1/1971" to h
Set ComItemHeight of hoItems h to 24
Set ComCellValueFormat of hoItems h 0 to OLEexHTML
Set ComFormatCell of hoItems h 0 to "`<b>` + year(value) + `</b><off -4> ` + day(value) + ` - ` + month(value)"
Set ComItemDivider of hoItems (ComAddItem(hoItems,"Predefined Date Formats")) to 0
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "value"
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "shortdateF(value)"
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "shortdate(value)"
Set ComFormatCell of hoItems (ComAddItem(hoItems,"12/1/1971")) 0 to "longdate(value)"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1896
|
I have noticed that the column gets resized once I release the mouse. I have a column that displays multiple-lines cells, and the text gets wrapped only when user releases the mouse. Is it possible to get resized contiguously as I had before
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to False
Set ComDrawGridLines to OLEexVLines
Set ComColumnsAllowSizing to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Column A (cont)" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexColumnResizeContiguously to True
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Get ComAdd of hoColumns1 "Column 1" to Nothing
Send Destroy to hoColumns1
Variant voColumns2
Get ComColumns to voColumns2
Handle hoColumns2
Get Create (RefClass(cComColumns)) to hoColumns2
Set pvComObject of hoColumns2 to voColumns2
Variant voColumn1
Get ComAdd of hoColumns2 "Column B (cont)" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexColumnResizeContiguously to True
Send Destroy to hoColumn1
Send Destroy to hoColumns2
Variant voColumns3
Get ComColumns to voColumns3
Handle hoColumns3
Get Create (RefClass(cComColumns)) to hoColumns3
Set pvComObject of hoColumns3 to voColumns3
Get ComAdd of hoColumns3 "Column 2" to Nothing
Send Destroy to hoColumns3
Send ComEndUpdate
End_Procedure
|
|
1895
|
How do I get the column from cursor, when it hovers the empty portion of the items section
// Occurs when the user moves the mouse.
Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComMouseMove llButton llShift llX llY
Variant i
Get ComItemFromPoint 0 -1 c hit to i
Showln "Column" c
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexVLines
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column 0" to Nothing
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Get ComAdd of hoColumns1 "Column 1" to Nothing
Send Destroy to hoColumns1
Variant voColumns2
Get ComColumns to voColumns2
Handle hoColumns2
Get Create (RefClass(cComColumns)) to hoColumns2
Set pvComObject of hoColumns2 to voColumns2
Get ComAdd of hoColumns2 "Column 2" to Nothing
Send Destroy to hoColumns2
Send ComEndUpdate
End_Procedure
|
|
1894
|
How do I add items once the user clicks the empty area
// Occurs when the user presses and then releases the left mouse button over the tree control.
Procedure OnComClick
Forward Send OnComClick
Variant i
Get ComItemFromPoint 0 -1 c hit to i
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellValue of hoItems (ComAddItem(hoItems,i)) 1 to c
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Number of Items to Add" to Nothing
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Get ComAdd of hoColumns1 "Click on Column" to Nothing
Send Destroy to hoColumns1
Send ComEndUpdate
End_Procedure
|
|
1893
|
Is there an easy way to get an effect like in a Microsoft Access / SQL-Server Table view, where you can scroll-up till the last row containing data is displayed as top-row
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems llItem "Task" (ComCellValue(hoItems,llItem,2)) (ComCellValue(hoItems,llItem,4)) Nothing Nothing
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComHasLines to OLEexNoLine
Set ComColumnAutoResize to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "Orders" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenKeyset OLEadLockReadOnly Nothing
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "10/21/1994"
Set ComLevelCount of hoChart to 2
Send Destroy to hoChart
Set ComDataSource to rs
Set ComScrollBars to (OLEexVScrollEmptySpace + OLEexBoth)
Variant v
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Get ComItemCount of hoItems1 to v
Send Destroy to hoItems1
Set ComScrollPos True to v
Send ComEndUpdate
End_Procedure
|
|
1892
|
Is there any option to stop events
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Showln "AddItem event is fired only if FreezeEvents(False) is called"
End_Procedure
// Occurs when the user links two bars using the mouse.
Procedure OnComAddLink String llLinkKey
Forward Send OnComAddLink llLinkKey
Showln "AddLink event is fired only if FreezeEvents(False) is called"
End_Procedure
// Occurs when a bar is moved or resized.
Procedure OnComBarResize HITEM llItem Variant llKey
Forward Send OnComBarResize llItem llKey
Showln "BarResize event is fired only if FreezeEvents(False) is called"
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComFreezeEvents True
Send ComBeginUpdate
Set ComDefaultItemHeight to 24
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h1
Get ComAddItem of hoItems "Task 1" to h1
Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "" Nothing
Variant h2
Get ComAddItem of hoItems "Task 2" to h2
Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/4/2001" "" Nothing
Send ComAddLink of hoItems "L1" h1 "" h2 ""
Get ComSchedulePDM of hoItems 0 "" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
Send ComFreezeEvents False
End_Procedure
|
|
1891
|
How do I specify a more intensive color if using RenderType property
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Set ComRenderType of hoAppearance to -16777216
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABN0GACAADACAxRDAMgBQKAAzQFAYahuGSGAAGMYxQgmFgAQhFcZQSKUOQTDKMIziYBYJhEMQyDAAUIjOKsIhkGYcZAGQBJCjWGodQLOEgwHIERQjEyUJAGGQIHhyPYbUbGUpQHKkeRtGqgBgoKhKEouNYgAbGYIwTRsdyfDSXBpEWwbDgkNQwWTDNoRDIUQStCysaYjOpnfrUAJ1P7FdQ1NJkXRhGSSK7maapaiCSZ6STCMj1FhVKSNJ7DQKhGpgKh/ApgYpQOK4fLNXyRBK4QAyKA6bgPFZOZbFViaXY1V5bNKrcjhHQwAyHJ4XXRdV4YRAkUT4GqiJKGSYcQhuXZWbRqO6ABhef6DRThc6jKpFHIE4llEcojHqSZNgoIxnlgd5thsLREleL43gsYZ9BkaAYkMAgAm+CxGDWWAtiKCRfjcdRgHoHYnicUwgAIEIREAaQYkcQZUHIGRUDQJBOEYRAhDYCxGgMZAkCgdYQhaXQIAYERwQuahXggdgeG6VZ4H4IhdiIGIOB8YIiGiHZZgqYpGF4KYHiKCI+CAU5jCiTQ2g0YhEFyax4gABAEIC" to Nothing
Get ComAdd of hoAppearance 2 "gBFLBCJwBAEHhEJAAEhABU0IQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjAKMEwsACEIrjKCRShyCYZRhGcTAJBMIhiGQYAChEZxVhEMgzDjIAxSJAcQRFESaAABGCQGh+N4/S4NIi0CIsZQjCaiZ7pKA5bgMCo+UrNMixZQVCSOGChYRpCaZWpGGodQRUFbVHAlKypJKCKrEWSrDhuYAAW7XM7yBS1TzVNSuLZtaLqSroAJ1WTWMB0Ra8NzZEKfaZACj4arKejrRDCMAggI=" to Nothing
Send Destroy to hoAppearance
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarHAlignCaption to 18
Set ComColor of hoBar to |CI$1000000
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComItem of hoBars1 "Summary" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComDef of hoBar1 OLEexBarHAlignCaption to 18
Set ComColor of hoBar1 to |CI$2000000
Send Destroy to hoBar1
Send Destroy to hoBars1
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummaryJ
Get ComAddItem of hoItems "Summary A" to hSummaryJ
Send ComAddBar of hoItems hSummaryJ "Summary" "1/2/2001" "1/2/2001" "J" Nothing
Variant hTaskJ
Get ComInsertItem of hoItems hSummaryJ "Task A.1" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/2/2001" "1/5/2001" "J1" Nothing
Get ComInsertItem of hoItems hSummaryJ "Task A.2" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/4/2001" "1/8/2001" "J2" Nothing
Send ComDefineSummaryBars of hoItems hSummaryJ "J" -1 "<*>"
Variant hSummaryK
Get ComAddItem of hoItems "Summary B" to hSummaryK
Send ComAddBar of hoItems hSummaryK "Summary" "1/2/2001" "1/2/2001" "K" Nothing
Variant hTaskK
Get ComInsertItem of hoItems hSummaryK "Task B.1" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummaryK "Task B.2" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Send ComDefineSummaryBars of hoItems hSummaryK "K" -1 "<*>"
Set ComItemBar of hoItems 0 "<K*>" OLEexBarColor to 255
Set ComExpandItem of hoItems 0 to True
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1890
|
How can I include the child items, when a filter is applied
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComColumnAutoResize to True
Set ComContinueColumnScroll to False
Set ComMarkSearchColumn to False
Set ComSearchColumnIndex to 1
Set ComIndent to 16
Set ComLinesAtRoot to OLEexLinesAtRoot
Set ComFilterBarPromptVisible to True
Set ComFilterBarPromptPattern to "Nancy"
Set ComFilterInclude to OLEexItemsWithChilds
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Name" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComWidth of hoColumn to 96
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "Title" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComWidth of hoColumn1 to 96
Send Destroy to hoColumn1
Get ComAdd of hoColumns "City" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h0
Get ComAddItem of hoItems "Nancy Davolio" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Seattle"
Get ComInsertItem of hoItems h0 "Andrew Fuller" to h0
Set ComCellValue of hoItems h0 1 to "Vice President, Sales"
Set ComCellValue of hoItems h0 2 to "Tacoma"
Get ComInsertItem of hoItems h0 "Michael Suyama" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Janet Leverling" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Kirkland"
Get ComInsertItem of hoItems h0 "Margaret Peacock" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Redmond"
Set ComExpandItem of hoItems 0 to True
Send Destroy to hoItems
Send ComApplyFilter
Send ComEndUpdate
End_Procedure
|
|
1889
|
Is it possible to change the date format shown when you scroll the horizontal bar on the chart
Procedure OnCreate
Forward Send OnCreate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComToolTip of hoChart to "<b>Date</b><br><%loc_ldate%>"
Send Destroy to hoChart
End_Procedure
|
|
1888
|
How do I change the drop down filter icon/button (white)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 2 "gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YNYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgbhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWBMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=" to Nothing
Get ComAdd of hoAppearance 1 "CP:2 -4 -4 2 4" to Nothing
Send Destroy to hoAppearance
Set ComBackground OLEexHeaderFilterBarButton to |CI$1000000
Set ComBackground OLEexCursorHoverColumn to (ComBackColor(Self))
Set ComHeaderAppearance to OLENone2
Set ComBackColorHeader to (RGB(255,255,255))
Set ComHeaderVisible to OLEexHeaderVisibleExtendLevels
Set ComHeaderHeight to 24
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Filter" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDisplayFilterButton of hoColumn to True
Set ComAllowSort of hoColumn to False
Set ComAllowDragging of hoColumn to False
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 196
Set ComLevelCount of hoChart to 2
Send Destroy to hoChart
Send ComEndUpdate
End_Procedure
|
|
1887
|
How do I prevent changing the cell's state ( check-box state )
// Fired before cell's state is about to be changed.
Procedure OnComCellStateChanging HITEM llItem Integer llColIndex Integer llNewState
Forward Send OnComCellStateChanging llItem llColIndex llNewState
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComCellState of hoItems llItem llColIndex to NewState
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComLinesAtRoot to OLEexLinesAtRoot
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "P1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComPartialCheck of hoColumn to True
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "P2" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellHasCheckBox to True
Set ComPartialCheck of hoColumn1 to True
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Variant h
Get ComAddItem of hoItems1 "Root" to h
Get ComInsertItem of hoItems1 h "Child 1" to Nothing
Get ComInsertItem of hoItems1 h "Child 2" to Nothing
Set ComExpandItem of hoItems1 h to True
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1886
|
How do I change the color of the columns's header to cover all levels
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexAllLines
Set ComBackColorLevelHeader to (ComBackColorHeader(Self))
Set ComHeaderAppearance to OLEEtched
Set ComDefaultItemHeight to 36
Set ComTreeColumnIndex to -1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "C1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComWidth of hoColumn to 24
Set ComAllowSizing of hoColumn to False
Set ComDef of hoColumn OLEexCellPaddingLeft to 3
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "C2" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellHasCheckBox to True
Set ComDef of hoColumn1 OLEexCellPaddingLeft to 2
Send Destroy to hoColumn1
Get ComAdd of hoColumns "Column1" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant v
Get ComBackColorHeader to v
Set ComBackColorLevelHeader of hoChart to v
Set ComLevelCount of hoChart to 2
Set ComDrawGridLines of hoChart to OLEexAllLines
Set ComFirstVisibleDate of hoChart to "6/22/2014"
Set ComPaneWidth of hoChart False to 256
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 1.2"
Set ComCellValue of hoItems h 2 to "Cell 1.3"
Send ComAddBar of hoItems h "Task" "6/23/2014" "6/25/2014" Nothing Nothing
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 2.2"
Set ComCellValue of hoItems h 2 to "Cell 2.3"
Send ComAddBar of hoItems h "Task" "6/26/2014" "6/28/2014" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1885
|
Is it possible to extend the columns's header to fill all levels
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexAllLines
Set ComHeaderVisible to OLEexHeaderVisibleExtendLevels
Set ComHeaderAppearance to OLEEtched
Set ComDefaultItemHeight to 36
Set ComTreeColumnIndex to -1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "C1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComWidth of hoColumn to 24
Set ComAllowSizing of hoColumn to False
Set ComDef of hoColumn OLEexCellPaddingLeft to 3
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "C2" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellHasCheckBox to True
Set ComDef of hoColumn1 OLEexCellPaddingLeft to 2
Send Destroy to hoColumn1
Get ComAdd of hoColumns "Column1" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant v
Get ComBackColorHeader to v
Set ComBackColorLevelHeader of hoChart to v
Set ComLevelCount of hoChart to 2
Set ComDrawGridLines of hoChart to OLEexAllLines
Set ComFirstVisibleDate of hoChart to "6/22/2014"
Set ComPaneWidth of hoChart False to 256
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 1.2"
Set ComCellValue of hoItems h 2 to "Cell 1.3"
Send ComAddBar of hoItems h "Task" "6/23/2014" "6/25/2014" Nothing Nothing
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 2.2"
Set ComCellValue of hoItems h 2 to "Cell 2.3"
Send ComAddBar of hoItems h "Task" "6/26/2014" "6/28/2014" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1884
|
How do I change the color of the columns's header to cover all levels (sample CRD)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexAllLines
Set ComBackColorLevelHeader to (ComBackColorHeader(Self))
Set ComHeaderAppearance to OLEEtched
Set ComDefaultItemHeight to 36
Set ComTreeColumnIndex to -1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "C1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComWidth of hoColumn to 24
Set ComAllowSizing of hoColumn to False
Set ComDef of hoColumn OLEexCellPaddingLeft to 3
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "C2" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellHasCheckBox to True
Set ComDef of hoColumn1 OLEexCellPaddingLeft to 2
Send Destroy to hoColumn1
Variant voColumn2
Get ComAdd of hoColumns "Column1" to voColumn2
Handle hoColumn2
Get Create (RefClass(cComColumn)) to hoColumn2
Set pvComObject of hoColumn2 to voColumn2
Set ComVisible of hoColumn2 to False
Send Destroy to hoColumn2
Variant voColumn3
Get ComAdd of hoColumns "Column2" to voColumn3
Handle hoColumn3
Get Create (RefClass(cComColumn)) to hoColumn3
Set pvComObject of hoColumn3 to voColumn3
Set ComVisible of hoColumn3 to False
Send Destroy to hoColumn3
Variant voColumn4
Get ComAdd of hoColumns "Column3" to voColumn4
Handle hoColumn4
Get Create (RefClass(cComColumn)) to hoColumn4
Set pvComObject of hoColumn4 to voColumn4
Set ComVisible of hoColumn4 to False
Send Destroy to hoColumn4
Variant voColumn5
Get ComAdd of hoColumns "FormatLevel" to voColumn5
Handle hoColumn5
Get Create (RefClass(cComColumn)) to hoColumn5
Set pvComObject of hoColumn5 to voColumn5
Set ComFormatLevel of hoColumn5 to "18;"Info"[a=17]/(2/3,4)"
Set ComDef of hoColumn5 OLEexCellFormatLevel to "2/3,4"
Send Destroy to hoColumn5
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComDrawGridLines of hoChart to OLEexAllLines
Set ComFirstVisibleDate of hoChart to "6/22/2014"
Set ComPaneWidth of hoChart False to 256
Variant v
Get ComBackColorHeader to v
Set ComBackColorLevelHeader of hoChart to v
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 1.2"
Set ComCellValue of hoItems h 2 to "Cell 1.3"
Send ComAddBar of hoItems h "Task" "6/23/2014" "6/25/2014" Nothing Nothing
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 2.2"
Set ComCellValue of hoItems h 2 to "Cell 2.3"
Send ComAddBar of hoItems h "Task" "6/26/2014" "6/28/2014" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1883
|
Is it possible to extend the columns's header to fill all levels (sample CRD)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexAllLines
Set ComHeaderVisible to OLEexHeaderVisibleExtendLevels
Set ComHeaderAppearance to OLEEtched
Set ComDefaultItemHeight to 36
Set ComTreeColumnIndex to -1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "C1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComWidth of hoColumn to 24
Set ComAllowSizing of hoColumn to False
Set ComDef of hoColumn OLEexCellPaddingLeft to 3
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "C2" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellHasCheckBox to True
Set ComDef of hoColumn1 OLEexCellPaddingLeft to 2
Send Destroy to hoColumn1
Variant voColumn2
Get ComAdd of hoColumns "Column1" to voColumn2
Handle hoColumn2
Get Create (RefClass(cComColumn)) to hoColumn2
Set pvComObject of hoColumn2 to voColumn2
Set ComVisible of hoColumn2 to False
Send Destroy to hoColumn2
Variant voColumn3
Get ComAdd of hoColumns "Column2" to voColumn3
Handle hoColumn3
Get Create (RefClass(cComColumn)) to hoColumn3
Set pvComObject of hoColumn3 to voColumn3
Set ComVisible of hoColumn3 to False
Send Destroy to hoColumn3
Variant voColumn4
Get ComAdd of hoColumns "Column3" to voColumn4
Handle hoColumn4
Get Create (RefClass(cComColumn)) to hoColumn4
Set pvComObject of hoColumn4 to voColumn4
Set ComVisible of hoColumn4 to False
Send Destroy to hoColumn4
Variant voColumn5
Get ComAdd of hoColumns "FormatLevel" to voColumn5
Handle hoColumn5
Get Create (RefClass(cComColumn)) to hoColumn5
Set pvComObject of hoColumn5 to voColumn5
Set ComFormatLevel of hoColumn5 to "18;"Info"[a=17]/(2/3,4)"
Set ComDef of hoColumn5 OLEexCellFormatLevel to "2/3,4"
Send Destroy to hoColumn5
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComDrawGridLines of hoChart to OLEexAllLines
Set ComFirstVisibleDate of hoChart to "6/22/2014"
Set ComPaneWidth of hoChart False to 256
Variant v
Get ComBackColorHeader to v
Set ComBackColorLevelHeader of hoChart to v
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 1.2"
Set ComCellValue of hoItems h 2 to "Cell 1.3"
Send ComAddBar of hoItems h "Task" "6/23/2014" "6/25/2014" Nothing Nothing
Get ComAddItem of hoItems "" to h
Set ComCellValue of hoItems h 1 to "Cell 2.2"
Set ComCellValue of hoItems h 2 to "Cell 2.3"
Send ComAddBar of hoItems h "Task" "6/26/2014" "6/28/2014" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1882
|
How do I get sorted the column as string, numeric, date, date and time. Also how can it be applied to drop down filter panel
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Date" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComSortType of hoColumn to OLESortDate
Set ComDisplayFilterButton of hoColumn to True
Set ComDisplayFilterPattern of hoColumn to False
Set ComDisplayFilterDate of hoColumn to True
Set ComFilterList of hoColumn to (OLEexShowFocusItem + OLEexShowCheckBox + OLEexSortItemsDesc)
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "DateTime" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComSortType of hoColumn1 to OLESortDateTime
Set ComDisplayFilterButton of hoColumn1 to True
Set ComDisplayFilterPattern of hoColumn1 to False
Set ComFilterList of hoColumn1 to (OLEexShowFocusItem + OLEexShowCheckBox + OLEexSortItemsDesc)
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voColumns2
Get ComColumns to voColumns2
Handle hoColumns2
Get Create (RefClass(cComColumns)) to hoColumns2
Set pvComObject of hoColumns2 to voColumns2
Variant voColumn2
Get ComAdd of hoColumns2 "Time" to voColumn2
Handle hoColumn2
Get Create (RefClass(cComColumn)) to hoColumn2
Set pvComObject of hoColumn2 to voColumn2
Set ComSortType of hoColumn2 to OLESortTime
Set ComDisplayFilterButton of hoColumn2 to True
Set ComDisplayFilterPattern of hoColumn2 to False
Set ComFilterList of hoColumn2 to (OLEexShowFocusItem + OLEexShowCheckBox + OLEexSortItemsDesc)
Set ComFormatColumn of hoColumn2 to "time(value)"
Send Destroy to hoColumn2
Send Destroy to hoColumns2
Variant voColumns3
Get ComColumns to voColumns3
Handle hoColumns3
Get Create (RefClass(cComColumns)) to hoColumns3
Set pvComObject of hoColumns3 to voColumns3
Variant voColumn3
Get ComAdd of hoColumns3 "Numeric" to voColumn3
Handle hoColumn3
Get Create (RefClass(cComColumn)) to hoColumn3
Set pvComObject of hoColumn3 to voColumn3
Set ComSortType of hoColumn3 to OLESortNumeric
Set ComDisplayFilterButton of hoColumn3 to True
Set ComFilterList of hoColumn3 to (OLEexShowFocusItem + OLEexShowCheckBox + OLEexSortItemsDesc)
Send Destroy to hoColumn3
Send Destroy to hoColumns3
Variant voColumns4
Get ComColumns to voColumns4
Handle hoColumns4
Get Create (RefClass(cComColumns)) to hoColumns4
Set pvComObject of hoColumns4 to voColumns4
Variant voColumn4
Get ComAdd of hoColumns4 "String" to voColumn4
Handle hoColumn4
Get Create (RefClass(cComColumn)) to hoColumn4
Set pvComObject of hoColumn4 to voColumn4
Set ComDisplayFilterButton of hoColumn4 to True
Set ComFilterList of hoColumn4 to (OLEexShowFocusItem + OLEexShowCheckBox + OLEexSortItemsDesc)
Send Destroy to hoColumn4
Send Destroy to hoColumns4
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "1/27/2010" to h
Set ComCellValue of hoItems h 1 to "1/27/2010 10:00:00 AM"
Set ComCellValue of hoItems h 2 to (ComCellValue(hoItems,h,1))
Set ComCellValue of hoItems h 3 to 1
Set ComCellValue of hoItems h 4 to (ComCellValue(hoItems,h,3))
Get ComAddItem of hoItems "1/27/2011" to h
Set ComCellValue of hoItems h 1 to "1/27/2011 9:00:00 AM"
Set ComCellValue of hoItems h 2 to (ComCellValue(hoItems,h,1))
Set ComCellValue of hoItems h 3 to 11
Set ComCellValue of hoItems h 4 to (ComCellValue(hoItems,h,3))
Get ComAddItem of hoItems "11/2/2010" to h
Set ComCellValue of hoItems h 1 to "11/2/2010 9:00:00 AM"
Set ComCellValue of hoItems h 2 to (ComCellValue(hoItems,h,1))
Set ComCellValue of hoItems h 3 to 2
Set ComCellValue of hoItems h 4 to (ComCellValue(hoItems,h,3))
Send Destroy to hoItems
Variant voColumns5
Get ComColumns to voColumns5
Handle hoColumns5
Get Create (RefClass(cComColumns)) to hoColumns5
Set pvComObject of hoColumns5 to voColumns5
Variant voColumn5
Get ComItem of hoColumns5 "DateTime" to voColumn5
Handle hoColumn5
Get Create (RefClass(cComColumn)) to hoColumn5
Set pvComObject of hoColumn5 to voColumn5
Set ComDisplayFilterDate of hoColumn5 to False
Send Destroy to hoColumn5
Send Destroy to hoColumns5
Send ComEndUpdate
End_Procedure
|
|
1881
|
Is there a way to set the time zone per item
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h1
Get ComAddItem of hoItems "Task A" to h1
Send ComAddBar of hoItems h1 "" "1/2/2001" "1/18/2001" "TZ1" "Time Zone / Item"
Set ComItemBar of hoItems h1 "TZ1" OLEexBarSelectable to False
Set ComItemBar of hoItems h1 "TZ1" OLEexBarBackColor to 255
Send ComAddBar of hoItems h1 "Task" "1/20/2001" "1/29/2001" "Z1" Nothing
Get ComAddItem of hoItems "Task B" to h1
Send ComAddBar of hoItems h1 "" "1/6/2001" "1/24/2001" "TZ2" "Time Zone / Item"
Set ComItemBar of hoItems h1 "TZ2" OLEexBarSelectable to False
Set ComItemBar of hoItems h1 "TZ2" OLEexBarBackColor to 65535
Send ComAddBar of hoItems h1 "Task" "1/3/2001" "1/12/2001" "Z1" Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1880
|
Is there a way to turn arrow-key-navigation between the items on and off
// Occurs when the user presses a key while an object has the focus.
Procedure OnComKeyDown Short llKeyCode Short llShift
Forward Send OnComKeyDown llKeyCode llShift
Move 0 to KeyCode
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Tasks" to Nothing
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn
Get ComAdd of hoColumns1 "Effort" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 21
Variant voEditor
Get ComEditor of hoColumn to voEditor
Handle hoEditor
Get Create (RefClass(cComEditor)) to hoEditor
Set pvComObject of hoEditor to voEditor
Set ComEditType of hoEditor to OLESpinType
Send Destroy to hoEditor
Send Destroy to hoColumn
Send Destroy to hoColumns1
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComNonworkingDays of hoChart to 0
Set ComPaneWidth of hoChart False to 96
Set ComFirstVisibleDate of hoChart to "6/20/2005"
Set ComHistogramVisible of hoChart to True
Set ComHistogramHeight of hoChart to 128
Set ComHistogramView of hoChart to OLEexHistogramAllItems
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHistogramPattern of hoBar to (ComPattern(hoBar))
Set ComHistogramType of hoBar to OLEexHistOverload
Set ComHistogramCriticalValue of hoBar to 3
Set ComShowHistogramValues of hoBar to "value>3?255:1"
Set ComHistogramItems of hoBar to -11
Set ComHistogramGridLinesColor of hoBar to (RGB(192,192,192))
Set ComHistogramRulerLinesColor of hoBar to (RGB(0,0,1))
Set ComFormatHistogramValues of hoBar to "value format `2`"
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComAllowCellValueToItemBar of hoItems to True
Variant h1
Get ComAddItem of hoItems "Task 1" to h1
Send ComAddBar of hoItems h1 "Task" "6/21/2005" "6/23/2005" Nothing Nothing
Set ComCellValue of hoItems h1 1 to 6.79
Get ComAddItem of hoItems "Task 2" to h1
Send ComAddBar of hoItems h1 "Task" "6/24/2005" "6/26/2005" Nothing Nothing
Set ComCellValue of hoItems h1 1 to 3.19
Get ComAddItem of hoItems "Task 3" to h1
Send ComAddBar of hoItems h1 "Task" "6/27/2005" "6/29/2005" Nothing Nothing
Set ComCellValue of hoItems h1 1 to 2
Get ComAddItem of hoItems "Task 4" to h1
Send ComAddBar of hoItems h1 "Task" "6/30/2005" "7/2/2005" Nothing Nothing
Set ComCellValue of hoItems h1 1 to 1
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1879
|
I am using Layout property to sort multiple columns at once. The problem is that all items get expanded. How do I prevent that
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComLinesAtRoot to OLEexLinesAtRoot
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "P1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComPartialCheck of hoColumn to True
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "P2" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellHasCheckBox to True
Set ComPartialCheck of hoColumn1 to True
Set ComFormatColumn of hoColumn1 to "1 index ``"
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child A" to Nothing
Get ComInsertItem of hoItems h "Child B" to Nothing
Get ComInsertItem of hoItems h "Child A" to Nothing
Get ComInsertItem of hoItems h "Child B" to Nothing
Get ComAddItem of hoItems "Root" to Nothing
Get ComAddItem of hoItems "Root" to Nothing
Send Destroy to hoItems
Set ComSingleSort to False
Set ComLayout to "multiplesort="C0:1 C1:2";collapse="""
Send ComEndUpdate
End_Procedure
|
|
1878
|
How can I decode the Layout property
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "C1" to Nothing
Variant voColumn
Get ComAdd of hoColumns "C2" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComPosition of hoColumn to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellValue of hoItems (ComAddItem(hoItems,"SubItem 1.1")) 1 to "SubItem 1.2"
Set ComCellValue of hoItems (ComAddItem(hoItems,"SubItem 2.1")) 1 to "SubItem 2.2"
Send Destroy to hoItems
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComItem of hoColumns1 "C2" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComSortOrder of hoColumn1 to OLESortDescending
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Send ComEndUpdate
Showln "Encoded:" (ComLayout(Self))
Handle hoPrint
Get Create (RefClass(cComPrint)) to hoPrint // Import the 'ExPrint 1.0 Control Library' library
Variant vText64
Get ComLayout to vText64
Showln "Decoded: " (ComDecode64TextW(hoPrint,vText64))
Send Destroy to hoPrint
End_Procedure
|
|
1877
|
Is it possible to define a bar inside a bar (method 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComDrawGridLines to OLEexHLines
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComDrawGridLines of hoChart to OLEexHLines
Set ComAllowCreateBar of hoChart to OLEexCreateBarAuto
Set ComAllowLinkBars of hoChart to False
Set ComResizeUnitScale of hoChart to OLEexHour
Set ComPaneWidth of hoChart False to 48
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComOverlaidType of hoBar to (OLEexOverlaidBarsStackAutoArrange + OLEexOverlaidBarsStack)
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Tasks" to h
Send ComAddBar of hoItems h "Task" "1/3/2001" "1/7/2001" "A1" Nothing
Send ComAddBar of hoItems h "Task" "1/4/2001" "1/8/2001" "A2" Nothing
Send ComAddBar of hoItems h "Task" "1/9/2001" "1/13/2001" "A3" Nothing
Send Destroy to hoItems
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Variant voNotes
Get ComNotes of hoChart1 to voNotes
Handle hoNotes
Get Create (RefClass(cComNotes)) to hoNotes
Set pvComObject of hoNotes to voNotes
Variant vItem
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Get ComFirstVisibleItem of hoItems1 to vItem
Send Destroy to hoItems1
Variant voNote
Get ComAdd of hoNotes "N1" vItem "A1" "" to voNote
Handle hoNote
Get Create (RefClass(cComNote)) to hoNote
Set pvComObject of hoNote to voNote
Set ComPartText of hoNote OLEexNoteStart to " "
Set ComPartFixedWidth of hoNote OLEexNoteStart to 18
Set ComPartFixedHeight of hoNote OLEexNoteStart to 11
Set ComPartCanMove of hoNote OLEexNoteStart to True
Set ComPartBackColor of hoNote OLEexNoteStart to (RGB(0,255,0))
Set ComPartVisible of hoNote OLEexNoteEnd to False
Set ComShowLink of hoNote to OLEexNoteLinkHidden
Set ComPartVOffset of hoNote OLEexNoteStart to 4
Send Destroy to hoNote
Send Destroy to hoNotes
Send Destroy to hoChart1
Send ComEndUpdate
End_Procedure
|
|
1876
|
Is it possible to define a bar inside a bar (method 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComDrawGridLines to OLEexHLines
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComDrawGridLines of hoChart to OLEexHLines
Set ComAllowCreateBar of hoChart to OLEexCreateBarAuto
Set ComAllowLinkBars of hoChart to False
Set ComResizeUnitScale of hoChart to OLEexHour
Set ComPaneWidth of hoChart False to 48
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComOverlaidType of hoBar to (OLEexOverlaidBarsStackAutoArrange + OLEexOverlaidBarsStack)
Set ComOverlaidGroup of hoBar to "Task,TaskB"
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComAdd of hoBars1 "Aka" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComColor of hoBar1 to (RGB(0,255,0))
Set ComPattern of hoBar1 to OLEexPatternSolid
Send Destroy to hoBar1
Send Destroy to hoBars1
Variant voBars2
Get ComBars of hoChart to voBars2
Handle hoBars2
Get Create (RefClass(cComBars)) to hoBars2
Set pvComObject of hoBars2 to voBars2
Variant voBar2
Get ComAdd of hoBars2 "Task%Aka" to voBar2
Handle hoBar2
Get Create (RefClass(cComBar)) to hoBar2
Set pvComObject of hoBar2 to voBar2
Set ComShortcut of hoBar2 to "TaskB"
Set ComOverlaidType of hoBar2 to (OLEexOverlaidBarsStackAutoArrange + OLEexOverlaidBarsStack)
Set ComOverlaidGroup of hoBar2 to "Task,TaskB"
Send Destroy to hoBar2
Send Destroy to hoBars2
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Tasks" to h
Send ComAddBar of hoItems h "TaskB" "1/3/2001" "1/7/2001" "A1" Nothing
Set ComItemBar of hoItems h "A1" OLEexBarPercent to 0.25
Send ComAddBar of hoItems h "Task" "1/4/2001" "1/8/2001" "A2" Nothing
Send ComAddBar of hoItems h "Task" "1/9/2001" "1/13/2001" "A3" Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1875
|
How do I show the bar with a solid color, no border (method 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComDrawGridLines to OLEexHLines
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComDrawGridLines of hoChart to OLEexHLines
Set ComAllowCreateBar of hoChart to OLEexCreateBarAuto
Set ComAllowLinkBars of hoChart to False
Set ComResizeUnitScale of hoChart to OLEexHour
Set ComPaneWidth of hoChart False to 48
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComColor of hoBar to (RGB(255,0,0))
Set ComPattern of hoBar to OLEexPatternSolid
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Task" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "" Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1874
|
How do I show the bar with a solid color, no border (method 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComDrawGridLines to OLEexHLines
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComDrawGridLines of hoChart to OLEexHLines
Set ComAllowCreateBar of hoChart to OLEexCreateBarAuto
Set ComAllowLinkBars of hoChart to False
Set ComResizeUnitScale of hoChart to OLEexHour
Set ComPaneWidth of hoChart False to 48
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComColor of hoBar to (RGB(255,0,0))
Set ComStartColor of hoBar to (ComColor(hoBar))
Set ComEndColor of hoBar to (ComColor(hoBar))
Set ComPattern of hoBar to OLEexPatternBox
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Task" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "" Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1873
|
How do I show the bar with a solid color, no border (method 3)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComDrawGridLines to OLEexHLines
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComDrawGridLines of hoChart to OLEexHLines
Set ComAllowCreateBar of hoChart to OLEexCreateBarAuto
Set ComAllowLinkBars of hoChart to False
Set ComResizeUnitScale of hoChart to OLEexHour
Set ComPaneWidth of hoChart False to 48
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Send Destroy to hoChart
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Set ComRenderType of hoAppearance to -1
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABJkIQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyDQKkEwsACEIrjKCRShyCYZRhGcTSBCIZBqEqSZLiEZRQiiCYsS5AcgPfKgAAFESNY5gSL5Yj2IjrRDCMAggI" to Nothing
Send Destroy to hoAppearance
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Variant voBars
Get ComBars of hoChart1 to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Variant voBar1
Get ComItem of hoBar "Task" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComColor of hoBar1 to |CI$10000ff
Send Destroy to hoBar1
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart1
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Task" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/5/2001" "" Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1872
|
How do I find the cell's type, or what the cell holds
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexRowLines
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Value" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComWidth of hoColumn to 24
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "Type" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComFormatColumn of hoColumn1 to "type(%0)"
Send Destroy to hoColumn1
Variant voColumn2
Get ComAdd of hoColumns "TypeAsString" to voColumn2
Handle hoColumn2
Get Create (RefClass(cComColumn)) to hoColumn2
Set pvComObject of hoColumn2 to voColumn2
Set ComFormatColumn of hoColumn2 to "(0 := type(%0)) array (`empty`, `null`, `short`, `long`, `float`, `double`, `currency`, `date`, `string`, `object`, `error`, `boolean`, `variant`, `any`, `reserved`, `decimal`, `char`, `byte`, `unsigned short`, `unsigned long`, `long on 64 bits`)"
Send Destroy to hoColumn2
Variant voColumn3
Get ComAdd of hoColumns "Length" to voColumn3
Handle hoColumn3
Get Create (RefClass(cComColumn)) to hoColumn3
Set pvComObject of hoColumn3 to voColumn3
Set ComFormatColumn of hoColumn3 to "len(%0)"
Send Destroy to hoColumn3
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems Nothing to Nothing
Get ComAddItem of hoItems "" to Nothing
Set ComCellValue of hoItems (ComAddItem(hoItems,Nothing)) 0 to (pvComObject(Self))
Set ComCellValue of hoItems (ComAddItem(hoItems,Nothing)) 0 to True
Set ComCellValue of hoItems (ComAddItem(hoItems,Nothing)) 0 to -1
Set ComCellValue of hoItems (ComAddItem(hoItems,Nothing)) 0 to -1
Set ComCellValue of hoItems (ComAddItem(hoItems,Nothing)) 0 to "1/1/2001"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1871
|
Is it possible to allow changing the bar's parent while bar's start/end margins should stay unchanged
// Occurs just before moving a bar from current item to another item.
Procedure OnComBarParentChange HITEM llItem Variant llKey HITEM llNewItem Boolean llCancel
Forward Send OnComBarParentChange llItem llKey llNewItem llCancel
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComSelectItem of hoItems llNewItem to True
Send Destroy to hoItems
Variant v
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Get ComCellCaption of hoItems1 llItem 0 to v
Send Destroy to hoItems1
Variant v1
Variant voItems2
Get ComItems to voItems2
Handle hoItems2
Get Create (RefClass(cComItems)) to hoItems2
Set pvComObject of hoItems2 to voItems2
Get ComCellCaption of hoItems2 llNewItem 0 to v1
Send Destroy to hoItems2
Showln "BarParentChange from " v " to " v1
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Members" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueFormat to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Set ComSelBackMode to OLEexTransparent
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant v2
Get ComSelBackColor to v2
Set ComSelBackColor of hoChart to v2
Set ComFirstVisibleDate of hoChart to "9/20/2006"
Set ComAllowLinkBars of hoChart to False
Set ComAllowCreateBar of hoChart to OLEexNoCreateBar
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 96
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarHAlignCaption to 18
Set ComDef of hoBar OLEexBarCanResize to False
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems3
Get ComItems to voItems3
Handle hoItems3
Get Create (RefClass(cComItems)) to hoItems3
Set pvComObject of hoItems3 to voItems3
Get ComAddItem of hoItems3 "Member <b>1</b>" to Nothing
Variant h
Get ComAddItem of hoItems3 "Member <b>2</b>" to h
Send ComAddBar of hoItems3 h "Task" "9/21/2006" "9/23/2006" "T102" "Task <b>102</b>"
Set ComItemBar of hoItems3 h "T102" OLEexBarCanMove to False
Set ComItemBar of hoItems3 h "T102" OLEexBarCanMoveToAnother to True
Get ComAddItem of hoItems3 "Member <b>3</b>" to Nothing
Get ComAddItem of hoItems3 "Member <b>4</b>" to Nothing
Send Destroy to hoItems3
Send ComEndUpdate
End_Procedure
|
|
1870
|
Is it possible to (un)highlight the day/night shifts
// Occurs when the user presses and then releases the left mouse button over the tree control.
Procedure OnComClick
Forward Send OnComClick
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComShowNonworkingDates of hoChart to False
Set ComShowNonworkingHours of hoChart to False
Set ComBackColor of hoChart to (RGB(255,255,255))
Send Destroy to hoChart
Send ComRefresh
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Set ComFirstVisibleDate of hoChart1 to "1/1/2001"
Set ComLevelCount of hoChart1 to 2
Set ComUnitScale of hoChart1 to OLEexDay
Set ComUnitWidth of hoChart1 to 64
Set ComPaneWidth of hoChart1 False to 0
Set ComNonworkingHours of hoChart1 to 15728895
Set ComNonworkingHoursPattern of hoChart1 to OLEexPatternSolid
Set ComNonworkingDaysPattern of hoChart1 to (ComNonworkingHoursPattern(hoChart1))
Set ComNonworkingHoursColor of hoChart1 to (RGB(240,240,240))
Set ComNonworkingDaysColor of hoChart1 to (RGB(212,212,212))
Set ComBackColor of hoChart1 to (RGB(250,250,250))
Send Destroy to hoChart1
Send ComEndUpdate
End_Procedure
|
|
1869
|
How can I add a vertical line at specified date-time
Procedure OnCreate
Forward Send OnCreate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 18
Set ComLevelCount of hoChart to 2
Set ComUnitWidth of hoChart to 32
Set ComFirstVisibleDate of hoChart to "1/1/2010"
Send ComMarkTimeZone of hoChart "M1" "1/5/2010" "1/5/2010" 16711680 "50:5;3"
Send ComMarkTimeZone of hoChart "M2" "1/6/2010" "1/6/2010" 16711680 ":5"
Send ComMarkTimeZone of hoChart "M3" "1/7/2010 10:00:00 AM" "1/7/2010 10:00:00 AM" 255 "50:3;;zone"
Send Destroy to hoChart
End_Procedure
|
|
1868
|
How do I clear all date-time zones
// Occurs when the user presses and then releases the left mouse button over the tree control.
Procedure OnComClick
Forward Send OnComClick
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Send ComRemoveTimeZone of hoChart "<*>"
Send Destroy to hoChart
End_Procedure
// Fired when right mouse button is clicked
Procedure OnComRClick
Forward Send OnComRClick
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Send ComRemoveTimeZone of hoChart1 "<Z*>"
Send Destroy to hoChart1
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Variant voChart2
Get ComChart to voChart2
Handle hoChart2
Get Create (RefClass(cComChart)) to hoChart2
Set pvComObject of hoChart2 to voChart2
Set ComPaneWidth of hoChart2 False to 18
Set ComLevelCount of hoChart2 to 2
Set ComFirstVisibleDate of hoChart2 to "1/1/2010"
Send ComMarkTimeZone of hoChart2 "Z1" "1/4/2010" "1/5/2010" 255 Nothing
Send ComMarkTimeZone of hoChart2 "Z2" "1/11/2010" "1/12/2010" 65280 Nothing
Send ComMarkTimeZone of hoChart2 "M1" "1/7/2010" "1/8/2010" 16711680 "50:5;3"
Send Destroy to hoChart2
End_Procedure
|
|
1867
|
How do I place a comment above/bellow the bar (sample 4)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 26
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 64
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarVAlignCaption to 18
Set ComDef of hoBar OLEexBarHAlignCaption to 0
Set ComDef of hoBar OLEexBarExtraCaption to " "
Set ComDef of hoBar OLEexBarExtraCaptionHAlign to 0
Set ComDef of hoBar OLEexBarExtraCaptionVAlign to 16
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Task" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/6/2001" "K1" "<font ;6>user comment"
Set ComItemBar of hoItems h "K1" OLEexBarExtraCaption to "<font ;6>user comment"
Send ComAddBar of hoItems h "Task" "1/9/2001" "1/13/2001" "K2" "<font ;6>user comment"
Set ComItemBar of hoItems h "K2" OLEexBarExtraCaption to "<font ;6>user comment"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1866
|
How do I place a comment above/bellow the bar (sample 3)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 26
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 64
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Task" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/6/2001" "K1" "<font ;6>user comment"
Set ComItemBar of hoItems h "K1" OLEexBarVAlignCaption to 18
Set ComItemBar of hoItems h "K1" OLEexBarHAlignCaption to 0
Set ComItemBar of hoItems h "K1" OLEexBarExtraCaption to "<font ;6>user comment"
Set ComItemBar of hoItems h "K1" OLEexBarExtraCaptionHAlign to 0
Set ComItemBar of hoItems h "K1" OLEexBarExtraCaptionVAlign to 16
Send ComAddBar of hoItems h "Task" "1/9/2001" "1/13/2001" "K2" "<font ;6>user comment"
Set ComItemBar of hoItems h "K2" OLEexBarExtraCaption to "<font ;6>user comment"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1865
|
How do I place a comment under the bar (sample 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 26
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 64
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarVAlignCaption to 18
Set ComDef of hoBar OLEexBarHAlignCaption to 0
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Task" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/6/2001" "K1" "<font ;6>user comment"
Send ComAddBar of hoItems h "Task" "1/9/2001" "1/13/2001" "K2" "<font ;6>user comment"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1864
|
How do I place a comment under the bar (sample 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 26
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 64
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Task" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/6/2001" "K1" "<font ;6>user comment"
Set ComItemBar of hoItems h "K1" OLEexBarVAlignCaption to 18
Set ComItemBar of hoItems h "K1" OLEexBarHAlignCaption to 0
Send ComAddBar of hoItems h "Task" "1/9/2001" "1/13/2001" "K2" "<font ;6>user comment"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1863
|
I am using exBarCanMoveToAnother to allow a bar to be moved from one item to another. The question is if it is possible somehow to highlight the current bar can be dropped to (sample 2)
// Occurs just before moving a bar from current item to another item.
Procedure OnComBarParentChange HITEM llItem Variant llKey HITEM llNewItem Boolean llCancel
Forward Send OnComBarParentChange llItem llKey llNewItem llCancel
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComSelectItem of hoItems llNewItem to True
Send Destroy to hoItems
Variant v
Variant voConditionalFormats
Get ComConditionalFormats to voConditionalFormats
Handle hoConditionalFormats
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats
Set pvComObject of hoConditionalFormats to voConditionalFormats
Variant voConditionalFormat
Get ComItem of hoConditionalFormats "NOTRED" to voConditionalFormat
Handle hoConditionalFormat
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat
Set pvComObject of hoConditionalFormat to voConditionalFormat
Get ComVerify of hoConditionalFormat llNewItem to v
Send Destroy to hoConditionalFormat
Send Destroy to hoConditionalFormats
Move v to Cancel
End_Procedure
// Occurs after the chart has been changed.
Procedure OnComChartEndChanging OLEBarOperationEnum llOperation
Forward Send OnComChartEndChanging llOperation
Set ComSelForeColor to |CI$8000000e
Set ComSelBackColor to |CI$8000000d
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant v1
Get ComSelBackColor to v1
Set ComSelBackColor of hoChart to v1
Send Destroy to hoChart
Variant voConditionalFormats1
Get ComConditionalFormats to voConditionalFormats1
Handle hoConditionalFormats1
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats1
Set pvComObject of hoConditionalFormats1 to voConditionalFormats1
Send ComClear of hoConditionalFormats1
Send Destroy to hoConditionalFormats1
End_Procedure
// Occurs when the chart is about to be changed.
Procedure OnComChartStartChanging OLEBarOperationEnum llOperation
Forward Send OnComChartStartChanging llOperation
Set ComSelForeColor to (ComForeColor(Self))
Set ComSelBackColor to (ComBackColor(Self))
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Set ComSelBackColor of hoChart1 to (ComBackColor(hoChart1))
Send Destroy to hoChart1
Variant voConditionalFormats2
Get ComConditionalFormats to voConditionalFormats2
Handle hoConditionalFormats2
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats2
Set pvComObject of hoConditionalFormats2 to voConditionalFormats2
Variant voConditionalFormat1
Get ComAdd of hoConditionalFormats2 "%0 contains `Allowed` " "RED" to voConditionalFormat1
Handle hoConditionalFormat1
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat1
Set pvComObject of hoConditionalFormat1 to voConditionalFormat1
Set ComEnabled of hoConditionalFormat1 to False
Send Destroy to hoConditionalFormat1
Send Destroy to hoConditionalFormats2
Variant voConditionalFormats3
Get ComConditionalFormats to voConditionalFormats3
Handle hoConditionalFormats3
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats3
Set pvComObject of hoConditionalFormats3 to voConditionalFormats3
Variant voConditionalFormat2
Get ComAdd of hoConditionalFormats3 "not ( %0 contains `Allowed` )" "NOTRED" to voConditionalFormat2
Handle hoConditionalFormat2
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat2
Set pvComObject of hoConditionalFormat2 to voConditionalFormat2
Set ComBackColor of hoConditionalFormat2 to |CI$1fefefe
Set ComChartBackColor of hoConditionalFormat2 to (ComBackColor(hoConditionalFormat2))
Send Destroy to hoConditionalFormat2
Send Destroy to hoConditionalFormats3
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABZkIQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyDQKkEwsACEIrjKCRShyCYZRrGUgRCKQahLEiTIhGUYJHgmK4tRoAUbyDBIGQSCCZYDmKA3fj0AI9P7FcgSABEEigNIxToOU4jFgeCR2TqQRK1BDQbQSFCaZrmMKIXICO40WBQFhTdLlRyBBKzLKtCyaBqWaZrWxZE72ZaFVTdOK6bDvGwoarid56X7beA2PgdZTjQi5cCxG5sLrTBZtYzfET3diOEYPQzHMpzDB7bxbGaXZBlGSZbjeGZBUjQc7yfSNMw/HqKZQ6cQwTAIgI" to Nothing
Send Destroy to hoAppearance
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Members" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueFormat to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voChart2
Get ComChart to voChart2
Handle hoChart2
Get Create (RefClass(cComChart)) to hoChart2
Set pvComObject of hoChart2 to voChart2
Variant v2
Get ComSelBackColor to v2
Set ComSelBackColor of hoChart2 to v2
Set ComFirstVisibleDate of hoChart2 to "9/20/2006"
Set ComAllowLinkBars of hoChart2 to False
Set ComAllowCreateBar of hoChart2 to OLEexNoCreateBar
Set ComAllowSelectObjects of hoChart2 to OLEexNoSelectObjects
Set ComLevelCount of hoChart2 to 2
Set ComPaneWidth of hoChart2 False to 96
Variant voBars
Get ComBars of hoChart2 to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComOverlaidType of hoBar to (OLEexOverlaidBarsIncludeCaption + OLEexOverlaidBarsStackAutoArrange + OLEexOverlaidBarsStack)
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart2
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Variant h
Get ComAddItem of hoItems1 "Member <b>1</b>" to h
Get ComAddItem of hoItems1 "Member <b>Allowed</b>" to h
Send ComAddBar of hoItems1 h "Task" "9/21/2006" "9/23/2006" "T102" "Task <b>102</b>"
Set ComItemBar of hoItems1 h "T102" OLEexBarHAlignCaption to 18
Set ComItemBar of hoItems1 h "T102" OLEexBarCanMoveToAnother to True
Get ComAddItem of hoItems1 "Member <b>Allowed</b>" to h
Get ComAddItem of hoItems1 "Member <b>4</b>" to h
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1862
|
I am using exBarCanMoveToAnother to allow a bar to be moved from one item to another. The question is if it is possible somehow to highlight the current bar can be dropped to (sample 1)
// Occurs just before moving a bar from current item to another item.
Procedure OnComBarParentChange HITEM llItem Variant llKey HITEM llNewItem Boolean llCancel
Forward Send OnComBarParentChange llItem llKey llNewItem llCancel
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComSelectItem of hoItems llNewItem to True
Send Destroy to hoItems
Variant v
Variant voConditionalFormats
Get ComConditionalFormats to voConditionalFormats
Handle hoConditionalFormats
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats
Set pvComObject of hoConditionalFormats to voConditionalFormats
Variant voConditionalFormat
Get ComItem of hoConditionalFormats "NOTRED" to voConditionalFormat
Handle hoConditionalFormat
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat
Set pvComObject of hoConditionalFormat to voConditionalFormat
Get ComVerify of hoConditionalFormat llNewItem to v
Send Destroy to hoConditionalFormat
Send Destroy to hoConditionalFormats
Move v to Cancel
End_Procedure
// Occurs after the chart has been changed.
Procedure OnComChartEndChanging OLEBarOperationEnum llOperation
Forward Send OnComChartEndChanging llOperation
Set ComSelForeColor to |CI$8000000e
Set ComSelBackColor to |CI$8000000d
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant v1
Get ComSelBackColor to v1
Set ComSelBackColor of hoChart to v1
Send Destroy to hoChart
Variant voConditionalFormats1
Get ComConditionalFormats to voConditionalFormats1
Handle hoConditionalFormats1
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats1
Set pvComObject of hoConditionalFormats1 to voConditionalFormats1
Send ComClear of hoConditionalFormats1
Send Destroy to hoConditionalFormats1
End_Procedure
// Occurs when the chart is about to be changed.
Procedure OnComChartStartChanging OLEBarOperationEnum llOperation
Forward Send OnComChartStartChanging llOperation
Set ComSelForeColor to (ComForeColor(Self))
Set ComSelBackColor to (ComBackColor(Self))
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Set ComSelBackColor of hoChart1 to (ComBackColor(hoChart1))
Send Destroy to hoChart1
Variant voConditionalFormats2
Get ComConditionalFormats to voConditionalFormats2
Handle hoConditionalFormats2
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats2
Set pvComObject of hoConditionalFormats2 to voConditionalFormats2
Variant voConditionalFormat1
Get ComAdd of hoConditionalFormats2 "%0 contains `Allowed` " "RED" to voConditionalFormat1
Handle hoConditionalFormat1
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat1
Set pvComObject of hoConditionalFormat1 to voConditionalFormat1
Set ComBackColor of hoConditionalFormat1 to (RGB(255,128,128))
Set ComChartBackColor of hoConditionalFormat1 to (ComBackColor(hoConditionalFormat1))
Send Destroy to hoConditionalFormat1
Send Destroy to hoConditionalFormats2
Variant voConditionalFormats3
Get ComConditionalFormats to voConditionalFormats3
Handle hoConditionalFormats3
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats3
Set pvComObject of hoConditionalFormats3 to voConditionalFormats3
Variant voConditionalFormat2
Get ComAdd of hoConditionalFormats3 "not ( %0 contains `Allowed` )" "NOTRED" to voConditionalFormat2
Handle hoConditionalFormat2
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat2
Set pvComObject of hoConditionalFormat2 to voConditionalFormat2
Set ComEnabled of hoConditionalFormat2 to False
Send Destroy to hoConditionalFormat2
Send Destroy to hoConditionalFormats3
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Members" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueFormat to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voChart2
Get ComChart to voChart2
Handle hoChart2
Get Create (RefClass(cComChart)) to hoChart2
Set pvComObject of hoChart2 to voChart2
Variant v2
Get ComSelBackColor to v2
Set ComSelBackColor of hoChart2 to v2
Set ComFirstVisibleDate of hoChart2 to "9/20/2006"
Set ComAllowLinkBars of hoChart2 to False
Set ComAllowCreateBar of hoChart2 to OLEexNoCreateBar
Set ComAllowSelectObjects of hoChart2 to OLEexNoSelectObjects
Set ComLevelCount of hoChart2 to 2
Set ComPaneWidth of hoChart2 False to 96
Variant voBars
Get ComBars of hoChart2 to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComOverlaidType of hoBar to (OLEexOverlaidBarsIncludeCaption + OLEexOverlaidBarsStackAutoArrange + OLEexOverlaidBarsStack)
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart2
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Variant h
Get ComAddItem of hoItems1 "Member <b>1</b>" to h
Get ComAddItem of hoItems1 "Member <b>Allowed</b>" to h
Send ComAddBar of hoItems1 h "Task" "9/21/2006" "9/23/2006" "T102" "Task <b>102</b>"
Set ComItemBar of hoItems1 h "T102" OLEexBarHAlignCaption to 18
Set ComItemBar of hoItems1 h "T102" OLEexBarCanMoveToAnother to True
Get ComAddItem of hoItems1 "Member <b>Allowed</b>" to h
Get ComAddItem of hoItems1 "Member <b>4</b>" to h
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1861
|
How can I check, if a specified item fits a specified conditional format expression
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems llItem "Task" (ComCellValue(hoItems,llItem,2)) (ComCellValue(hoItems,llItem,4)) Nothing Nothing
Send Destroy to hoItems
End_Procedure
// Occurs when the user moves the mouse.
Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComMouseMove llButton llShift llX llY
Variant h
Get ComItemFromPoint -1 -1 c hit to h
Variant v
Variant voConditionalFormats
Get ComConditionalFormats to voConditionalFormats
Handle hoConditionalFormats
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats
Set pvComObject of hoConditionalFormats to voConditionalFormats
Variant voConditionalFormat
Get ComItem of hoConditionalFormats "RED" to voConditionalFormat
Handle hoConditionalFormat
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat
Set pvComObject of hoConditionalFormat to voConditionalFormat
Get ComVerify of hoConditionalFormat h to v
Send Destroy to hoConditionalFormat
Send Destroy to hoConditionalFormats
Showln v
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "8/3/1994"
Set ComPaneWidth of hoChart False to 256
Set ComLevelCount of hoChart to 2
Set ComUnitScale of hoChart to OLEexDay
Set ComFirstWeekDay of hoChart to OLEexMonday
Send Destroy to hoChart
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Variant v1
Get ComSelBackColor to v1
Set ComSelBackColor of hoChart1 to v1
Send Destroy to hoChart1
Set ComSelBackMode to OLEexTransparent
Set ComColumnAutoResize to False
Set ComContinueColumnScroll to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "Orders" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenStatic OLEadLockOptimistic Nothing
Set ComDataSource to rs
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Set ComAllowCellValueToItemBar of hoItems1 to True
Send Destroy to hoItems1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComItem of hoColumns 2 to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComItem of hoColumns1 4 to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellValueToItemBarProperty to 2
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voConditionalFormats1
Get ComConditionalFormats to voConditionalFormats1
Handle hoConditionalFormats1
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats1
Set pvComObject of hoConditionalFormats1 to voConditionalFormats1
Variant voConditionalFormat1
Get ComAdd of hoConditionalFormats1 "%1 = 5" "RED" to voConditionalFormat1
Handle hoConditionalFormat1
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat1
Set pvComObject of hoConditionalFormat1 to voConditionalFormat1
Set ComBackColor of hoConditionalFormat1 to (RGB(255,128,128))
Set ComChartBackColor of hoConditionalFormat1 to (ComBackColor(hoConditionalFormat1))
Send Destroy to hoConditionalFormat1
Send Destroy to hoConditionalFormats1
Send ComEndUpdate
End_Procedure
|
|
1860
|
Is it possible to apply the conditional format on the items shown on the chart part of the control (sample 3)
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems llItem "Task" (ComCellValue(hoItems,llItem,2)) (ComCellValue(hoItems,llItem,4)) Nothing Nothing
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComSelBackMode to OLEexTransparent
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant v
Get ComSelBackColor to v
Set ComSelBackColor of hoChart to v
Set ComFirstVisibleDate of hoChart to "8/3/1994"
Set ComPaneWidth of hoChart False to 256
Set ComLevelCount of hoChart to 2
Set ComUnitScale of hoChart to OLEexDay
Set ComFirstWeekDay of hoChart to OLEexMonday
Send Destroy to hoChart
Set ComColumnAutoResize to False
Set ComContinueColumnScroll to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "Orders" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenStatic OLEadLockOptimistic Nothing
Set ComDataSource to rs
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Set ComAllowCellValueToItemBar of hoItems1 to True
Send Destroy to hoItems1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComItem of hoColumns 2 to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComItem of hoColumns1 4 to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellValueToItemBarProperty to 2
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voConditionalFormats
Get ComConditionalFormats to voConditionalFormats
Handle hoConditionalFormats
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats
Set pvComObject of hoConditionalFormats to voConditionalFormats
Variant voConditionalFormat
Get ComAdd of hoConditionalFormats "%1 in (3,5)" Nothing to voConditionalFormat
Handle hoConditionalFormat
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat
Set pvComObject of hoConditionalFormat to voConditionalFormat
Set ComApplyToBars of hoConditionalFormat to "Task"
Set ComBarColor of hoConditionalFormat to (RGB(255,0,0))
Set ComBarOverviewColor of hoConditionalFormat to (RGB(255,0,0))
Set ComForeColor of hoConditionalFormat to (ComBarColor(hoConditionalFormat))
Set ComBold of hoConditionalFormat to True
Send Destroy to hoConditionalFormat
Send Destroy to hoConditionalFormats
Send ComEndUpdate
End_Procedure
|
|
1859
|
Is it possible to apply the conditional format on the items shown on the chart part of the control (sample 2)
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems llItem "Task" (ComCellValue(hoItems,llItem,2)) (ComCellValue(hoItems,llItem,4)) Nothing Nothing
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComSelBackMode to OLEexTransparent
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant v
Get ComSelBackColor to v
Set ComSelBackColor of hoChart to v
Set ComFirstVisibleDate of hoChart to "8/3/1994"
Set ComPaneWidth of hoChart False to 256
Set ComLevelCount of hoChart to 2
Set ComUnitScale of hoChart to OLEexDay
Set ComFirstWeekDay of hoChart to OLEexMonday
Send Destroy to hoChart
Set ComColumnAutoResize to False
Set ComContinueColumnScroll to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "Orders" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenStatic OLEadLockOptimistic Nothing
Set ComDataSource to rs
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Set ComAllowCellValueToItemBar of hoItems1 to True
Send Destroy to hoItems1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComItem of hoColumns 2 to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComItem of hoColumns1 4 to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellValueToItemBarProperty to 2
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voConditionalFormats
Get ComConditionalFormats to voConditionalFormats
Handle hoConditionalFormats
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats
Set pvComObject of hoConditionalFormats to voConditionalFormats
Variant voConditionalFormat
Get ComAdd of hoConditionalFormats "%1 in (3,5)" Nothing to voConditionalFormat
Handle hoConditionalFormat
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat
Set pvComObject of hoConditionalFormat to voConditionalFormat
Set ComApplyTo of hoConditionalFormat to |CI$1
Set ComBackColor of hoConditionalFormat to (RGB(255,128,128))
Send Destroy to hoConditionalFormat
Variant voConditionalFormat1
Get ComAdd of hoConditionalFormats "%1 in (3,5)" Nothing to voConditionalFormat1
Handle hoConditionalFormat1
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat1
Set pvComObject of hoConditionalFormat1 to voConditionalFormat1
Set ComApplyToBars of hoConditionalFormat1 to "Task"
Set ComBarColor of hoConditionalFormat1 to (RGB(255,0,0))
Set ComBarOverviewColor of hoConditionalFormat1 to (RGB(255,0,0))
Set ComChartBackColor of hoConditionalFormat1 to (RGB(255,128,128))
Send Destroy to hoConditionalFormat1
Send Destroy to hoConditionalFormats
Send ComEndUpdate
End_Procedure
|
|
1858
|
Is it possible to apply the conditional format on the items shown on the chart part of the control (sample 1)
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems llItem "Task" (ComCellValue(hoItems,llItem,2)) (ComCellValue(hoItems,llItem,4)) Nothing Nothing
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "8/3/1994"
Set ComPaneWidth of hoChart False to 256
Set ComLevelCount of hoChart to 2
Set ComUnitScale of hoChart to OLEexDay
Set ComFirstWeekDay of hoChart to OLEexMonday
Send Destroy to hoChart
Set ComSelBackMode to OLEexTransparent
Set ComBackColorAlternate to (RGB(240,240,240))
Set ComColumnAutoResize to False
Set ComContinueColumnScroll to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "Orders" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenStatic OLEadLockOptimistic Nothing
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Variant v
Get ComSelBackColor to v
Set ComSelBackColor of hoChart1 to v
Send Destroy to hoChart1
Set ComDataSource to rs
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Set ComAllowCellValueToItemBar of hoItems1 to True
Send Destroy to hoItems1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComItem of hoColumns 2 to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 1
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComItem of hoColumns1 4 to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellValueToItemBarProperty to 2
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voConditionalFormats
Get ComConditionalFormats to voConditionalFormats
Handle hoConditionalFormats
Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats
Set pvComObject of hoConditionalFormats to voConditionalFormats
Variant voConditionalFormat
Get ComAdd of hoConditionalFormats "%1 in (3,5)" Nothing to voConditionalFormat
Handle hoConditionalFormat
Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat
Set pvComObject of hoConditionalFormat to voConditionalFormat
Set ComApplyToBars of hoConditionalFormat to "Task"
Set ComBarColor of hoConditionalFormat to (RGB(255,0,0))
Set ComBarOverviewColor of hoConditionalFormat to (RGB(255,0,0))
Set ComBackColor of hoConditionalFormat to (RGB(255,128,128))
Set ComChartBackColor of hoConditionalFormat to (RGB(255,128,128))
Send Destroy to hoConditionalFormat
Send Destroy to hoConditionalFormats
Send ComEndUpdate
End_Procedure
|
|
1857
|
How can I get ride / hide the image being dragged by OLE Drag and Drop
// Occurs when the OLEDrag method is called.
Procedure OnComOLEStartDrag Variant llData Integer llAllowedEffects
Forward Send OnComOLEStartDrag llData llAllowedEffects
// Data.SetData("data to drag")
Move 1 to AllowedEffects
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Set ComOLEDropMode to OLEexOLEDropManual
Set ComBackground OLEexDragDropAfter to (RGB(255,255,255))
Set ComLinesAtRoot to OLEexLinesAtRoot
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Default" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child 1" to Nothing
Get ComInsertItem of hoItems h "Child 2" to Nothing
Set ComExpandItem of hoItems h to True
Send Destroy to hoItems
End_Procedure
|
|
1856
|
How do I change the visual appearance of the split bars
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 24
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABEgDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGMYhTgmFgAQhFcZQSB0Eg1BKMYwjOJgFgmEQxDQNIBQSLIYQiGSWZBGUBJDjWGgyQjOEByDIMRwjE6UZBgeCRViEMo9RrSEZSLAdGRFAaVYDdULBEACU5VRZQFCwTQcBhpIyoZpkECobh2TYgQjYNT1NSkLxeGoSbbuGhBQrOAw1XTEMhyDR0LTJM6bMBACqrBi2L4xURfOBRXLQAYbHjAZ7rSgacjKRpKRbmAV4Oh+O5pQjadp1TidNwHLoAK7nGwbbgmfwAZrAdjABj1HgBNS2dDkaabQrKEZ4XYAHAXVROOQTWIANb2XC4bwSLAwTJJYzjThiC2GInFOOQckiVw6AeCIvHSBzkCwDxfE6WZ2jsehICadx5kGYZdDgMRrA2c4NmWY56jyGxgEQJIgGkGJHEGVByBkWoCjkNAAAQIQ2AYRoDGQJAoKuZYgBgRZHggHZqAkAZDjYGA7E8KB0kyB5LiiBgigiYhIgiQ4Jk4WIkn6CphjQDgbDmIwDBIMg3GMQ4uDaDZjgiZg6DIY5DGIPg/GQBAMneEJMFkFJqhGTppCYSoSmSSQ2EoPJlAMIhSDmZREAyVYVk0eRkm+FpkmkdhehaTp4iSZQxiYRAODIMQODmJJxhqTwJjYbobmcCZGHKGxLjmVQDC+J4DiYeg8GGWYuH6H5oAoBoCgcTwimaBodmeGZongPRPCoCoOiOZ5qBIIoiAuaZomkPoPGOToEiaaZKHaHYfiUA5OhMAAngoVh6iYKYqHqKoqmGWoGiOKRkHOKJ7D2TxKgaNotmuCpmFAPQrkqPh4iwaw6laOowmwOpwnSL4LmiXJ9D4TxbBqTozm0CxGjwPRtEsIJsjWT4Dlydo1C2Sx2l6N5uAOWpijIDpbhYQ42i4K4mmqOpukuMpnjIJIjmKco5m8S5WnaPZkDuSJ4h0S46FKcY8m+DAHAGPovkoUhgD4cILmsCpCnCTA2nKQgPhwFokh4JpjmsFpEDGDBnBqRpwgwWJ6kSKhZjie5FnGTIXCWR4yAmYh+D+D48g8HpLnMDJHDIPoylObwpWIY5/CyTJzkydw1kSIhzA6ZQ7E+fJrDWUZ0g0JxKksT5NDSPJTmUaRcmAN5Nn0FJ/lMdYNGcWpWnWHRaGAMZ2AQDoEDKNhLicVpViQDYnGqWpPl2HxFDQNwJgoLoGGaCcDInRdjMCuNYbovR2D2FyNgNIcAJC5FWKwNwcBqAzCWBoPgTA8BkEwFwN4HRjjyAMH8EgcQ5CaGIFoAAHQ3AgAAIAQBAQ==" to Nothing
Get ComAdd of hoAppearance 2 "gBFLBCJwBAEHhEJAAEhABBYDg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGMYhTgmFgAQhFcZQSB0Eg1BKMYwjOJgFgmEQxDQNIBQSLIYQiGSWZTgMYRSASI43RoMUIzVAcQxDEaIZLlGQYHgkNIhDJPcZ0VDUbQGBiQIRmIAHNBwJJUVZFdBDLQkQy5HapZDkECobA+CZQTzUUI1LS9WS1HYaRJle4YRDUMJyQjdV4TRINHQvMinYzqOzrOhaW5TSzLcqyCK0SxxR4AJ4yGobJjiQYJShXcxyDQ8dyZC7PQohG7ofxUAKDVjhMjZRQeMS9JCwaThHElRQHMyBdJkKA9Iq2WaGXBeeQ3JbNbzrYzHb5hHZgAzTOoWbzWFT8BJOFOCAYGcJJjHGTh+C2H40AAL5ckyBQDFkKoWHYLw9iGTpGDUY4zkIdwbF8JhbgMc5hF6OJ8C6BhTkOcBAlsR4NnQaAflAIQJBQBoRgwdAdEcIYVEUQJBGYOBCBMYQUGgNhCEKB5FB4VBBgQXJgF+IAzA4Ig5GIQIQBwOxiGiIgngoYpIi4LoKiMA5KDIMwjEKakmk6OJkkmDpNgidgtgwI55AYJw5iQQwSEYNxkgiZJrEITppDSc4TkyCREmeFJkCkAkLmWAwWFoOolkkNheDuJJJDSb4YmIQ4UkaGZlFkVJVhqTR5jYYw7mWeQ1AkPAnEmVh1C6Z4JiYL4KGQYwQmOH5PBoBh2h0EIaAaBg8GMI5Ij6IpokoNoOiOaJDiaEoiA8KgegGIRpGoZoaiaaZDmCdYlGkZAmgmKJqEqFomimaoKCaIoqGqSo2iwQhknqRoyiyaxKlaNotk8OpCjiLprkqbQJD0LALAaQowmwSwWkaMZQhOVpKjKbJLDaTozm0CxFAkPYtEsVpWjWbYLGaWo2lCGRil6N5pAuBpiDsbhLH6Zo3G4ax6HhYgpFibYjCWa4ml4QhPguVp2D4b4Li6bYPmiSZWngPhvGuWQJj+b5zmsBo+iePAmDCIwoGwGJ6kEL4MA8EJDjCC46FWQwoBObwGkQD4UCcDpDg+PIHBWPpiHwYJxD+MgcH8BpH4cBJ7kicIrnKC4hg+fIjCoPoQhyOwuD8M5CnMPpJCMCIIkOOQOlOfw1k6MnJDwPw0GOfhvDGdQNAIKdalOAJfDedJdC8SxCeyNJQleZhdEoJ4iEyLYWlWVx0GQJJslqTQtjcVJYi6aZ8mMM43EmFwCECJkfYyWiDuAuG0EgdBNB8AYHYMgxwEM1EAIAgIA==" to Nothing
Get ComAdd of hoAppearance 3 "CP:2 -2 -2 2 2" to Nothing
Send Destroy to hoAppearance
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 48
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComAdd of hoBars "A" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHeight of hoBar to 15
Set ComColor of hoBar to |CI$2000000
Set ComPattern of hoBar to OLEexPatternBDiagonal
Send Destroy to hoBar
Variant voBar1
Get ComAdd of hoBars "Task:A" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComShortcut of hoBar1 to "Task"
Set ComHeight of hoBar1 to 15
Set ComColor of hoBar1 to |CI$1000000
Set ComDef of hoBar1 OLEexBarKeepWorkingCount to True
Send Destroy to hoBar1
Send Destroy to hoBars
Set ComNonworkingDaysColor of hoChart to (RGB(240,240,240))
Set ComSelBarColor of hoChart to (RGB(0,0,255))
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 1")) "Task" "1/2/2001" "1/16/2001" Nothing Nothing
Variant h
Get ComAddItem of hoItems "Task 2" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/16/2001" "" Nothing
Set ComItemBar of hoItems h "" OLEexBarColor to 65535
Get ComAddItem of hoItems "Task 3" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/16/2001" "" Nothing
Set ComItemBar of hoItems h "" OLEexBarSelected to True
Get ComAddItem of hoItems "Task 4" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/16/2001" "" Nothing
Set ComItemBar of hoItems h "" OLEexBarNonWorkingColor to 58753152
Get ComAddItem of hoItems "Task 5" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/16/2001" "" Nothing
Set ComItemBar of hoItems h "" OLEexBarNonWorkingColor to 25198720
Get ComAddItem of hoItems "Task 6" to h
Send ComAddBar of hoItems h "Task" "1/2/2001" "1/16/2001" "" Nothing
Set ComItemBar of hoItems h "" OLEexBarNonWorkingColor to 2130771712
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1855
|
Is there a way to display automatically the duration ( days, hours, minutes ) of the bar next to it
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Tasks" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 36
Send Destroy to hoColumn
Send Destroy to hoColumns
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 64
Set ComFirstVisibleDate of hoChart to "4/6/2009"
Set ComLevelCount of hoChart to 2
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComAdd of hoBars "Task:Progress" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComShortcut of hoBar to "TaskS"
Set ComDef of hoBar OLEexBarCaption to "<%=((1:=int(0:= (%258))) != 0 ? (=:1 + ' day(s)') : '') + (=:1 ? ' ' : '' ) + ((1:=int(0:=((=:0 - =:1 + 1/24/60/60/2)*24))) != 0 ? =:1 + ' hour(s)' : '' ) + (=:1 ? ' ' : '' ) + ((1:=round((=:0 - =:1)*60)) != 0 ? =:1 + ' min(s)' : '')%>"
Send Destroy to hoBar
Send Destroy to hoBars
Set ComResizeUnitScale of hoChart to OLEexMinute
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"T1")) "TaskS" "4/10/2009 2:30:00 AM" "4/16/2009 2:30:00 AM" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"T2")) "TaskS" "4/14/2009 9:00:00 AM" "4/22/2009 10:10:00 AM" Nothing Nothing
Set ComItemBar of hoItems 0 "<*>" OLEexBarKeepWorkingCount to True
Set ComItemBar of hoItems 0 "<*>" OLEexBarHAlignCaption to 18
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1854
|
Is there a way to display automatically the duration ( days, hours, minutes ) of the bar next to it
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Tasks" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 36
Send Destroy to hoColumn
Send Destroy to hoColumns
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 64
Set ComFirstVisibleDate of hoChart to "4/6/2009"
Set ComLevelCount of hoChart to 2
Set ComUnitScale of hoChart to OLEexHour
Set ComResizeUnitScale of hoChart to OLEexMinute
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarCaption to "<%=((1:=int(0:= (%513))) != 0 ? (=:1 + ' day(s)') : '') + (=:1 ? ' ' : '' ) + ((1:=int(0:=((=:0 - =:1 + 1/24/60/60/2)*24))) != 0 ? =:1 + ' hour(s)' : '' ) + (=:1 ? ' ' : '' ) + ((1:=round((=:0 - =:1)*60)) != 0 ? =:1 + ' min(s)' : '')%>"
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"T1")) "Task" "4/6/2009 2:30:00 AM" "4/6/2009 12:35:00 PM" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"T2")) "Task" "4/6/2009 9:00:00 AM" "4/6/2009 10:10:00 AM" Nothing Nothing
Set ComItemBar of hoItems 0 "<*>" OLEexBarHAlignCaption to 18
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1853
|
Does it support single or multiple split pane views
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComBackground OLEexSplitBar to (RGB(128,128,128))
Set ComBackground OLEexCSplitBar to (RGB(40,40,40))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 76
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Summary" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComPattern of hoBar to OLEexPatternShadow
Set ComShape of hoBar to OLEexShapeSolidDown
Set ComColor of hoBar to (RGB(0,0,255))
Set ComStartColor of hoBar to (ComColor(hoBar))
Set ComEndColor of hoBar to (ComColor(hoBar))
Send Destroy to hoBar
Send Destroy to hoBars
Set ComAllowSplitPane of hoChart to (OLEexAllowTwoSplitPane + OLEexAllowOneSplitPane)
Set ComSplitPaneWidth of hoChart to "128,128"
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummary
Get ComAddItem of hoItems "Summary" to hSummary
Send ComAddBar of hoItems hSummary "Summary" "1/2/2001" "1/2/2001" "" Nothing
Variant hTask
Get ComInsertItem of hoItems hSummary "Task A" to hTask
Send ComAddBar of hoItems hTask "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummary "Task B" to hTask
Send ComAddBar of hoItems hTask "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Get ComInsertItem of hoItems hSummary "Task C" to hTask
Send ComAddBar of hoItems hTask "Task" "2/23/2001" "2/27/2001" "K3" Nothing
Set ComExpandItem of hoItems hSummary to True
Send ComDefineSummaryBars of hoItems hSummary "" -1 "<*>"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1852
|
How can I programmatically add more split panes ( by code)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComBackground OLEexSplitBar to (RGB(128,128,128))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 76
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Summary" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComPattern of hoBar to OLEexPatternShadow
Set ComShape of hoBar to OLEexShapeSolidDown
Set ComColor of hoBar to (RGB(0,0,255))
Set ComStartColor of hoBar to (ComColor(hoBar))
Set ComEndColor of hoBar to (ComColor(hoBar))
Send Destroy to hoBar
Send Destroy to hoBars
Set ComAllowSplitPane of hoChart to OLEexAllowOneSplitPane
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummary
Get ComAddItem of hoItems "Summary" to hSummary
Send ComAddBar of hoItems hSummary "Summary" "1/2/2001" "1/2/2001" "" Nothing
Variant hTask
Get ComInsertItem of hoItems hSummary "Task A" to hTask
Send ComAddBar of hoItems hTask "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummary "Task B" to hTask
Send ComAddBar of hoItems hTask "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Get ComInsertItem of hoItems hSummary "Task C" to hTask
Send ComAddBar of hoItems hTask "Task" "2/23/2001" "2/27/2001" "K3" Nothing
Set ComExpandItem of hoItems hSummary to True
Send ComDefineSummaryBars of hoItems hSummary "" -1 "<*>"
Send Destroy to hoItems
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Send ComScrollTo of hoChart1 (ComEndPrintDate(hoChart1)) 1
Set ComSplitPaneWidth of hoChart1 to "128,128,128"
Send ComScrollTo of hoChart1 (ComStartPrintDate(hoChart1)) 1
Send Destroy to hoChart1
Send ComEndUpdate
End_Procedure
|
|
1851
|
How can I programmatically add a split pane, or adding a split view at runtime
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComBackground OLEexCSplitBar to (RGB(40,40,40))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 76
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Summary" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComPattern of hoBar to OLEexPatternShadow
Set ComShape of hoBar to OLEexShapeSolidDown
Set ComColor of hoBar to (RGB(0,0,255))
Set ComStartColor of hoBar to (ComColor(hoBar))
Set ComEndColor of hoBar to (ComColor(hoBar))
Send Destroy to hoBar
Send Destroy to hoBars
Set ComAllowSplitPane of hoChart to OLEexAllowOneSplitPane
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummary
Get ComAddItem of hoItems "Summary" to hSummary
Send ComAddBar of hoItems hSummary "Summary" "1/2/2001" "1/2/2001" "" Nothing
Variant hTask
Get ComInsertItem of hoItems hSummary "Task A" to hTask
Send ComAddBar of hoItems hTask "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummary "Task B" to hTask
Send ComAddBar of hoItems hTask "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Get ComInsertItem of hoItems hSummary "Task C" to hTask
Send ComAddBar of hoItems hTask "Task" "2/23/2001" "2/27/2001" "K3" Nothing
Set ComExpandItem of hoItems hSummary to True
Send ComDefineSummaryBars of hoItems hSummary "" -1 "<*>"
Send Destroy to hoItems
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Send ComScrollTo of hoChart1 (ComEndPrintDate(hoChart1)) 1
Set ComSplitPaneWidth of hoChart1 to "128"
Send ComScrollTo of hoChart1 (ComStartPrintDate(hoChart1)) 1
Send Destroy to hoChart1
Send ComEndUpdate
End_Procedure
|
|
1850
|
Is there any way, property, procedure or anything else to split the control into multiple views
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Set ComBackground OLEexCSplitBar to (RGB(40,40,40))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 76
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Summary" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComPattern of hoBar to OLEexPatternShadow
Set ComShape of hoBar to OLEexShapeSolidDown
Set ComColor of hoBar to (RGB(0,0,255))
Set ComStartColor of hoBar to (ComColor(hoBar))
Set ComEndColor of hoBar to (ComColor(hoBar))
Send Destroy to hoBar
Send Destroy to hoBars
Set ComAllowSplitPane of hoChart to OLEexAllowOneSplitPane
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummary
Get ComAddItem of hoItems "Summary" to hSummary
Send ComAddBar of hoItems hSummary "Summary" "1/2/2001" "1/2/2001" "" Nothing
Variant hTask
Get ComInsertItem of hoItems hSummary "Task A" to hTask
Send ComAddBar of hoItems hTask "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummary "Task B" to hTask
Send ComAddBar of hoItems hTask "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Get ComInsertItem of hoItems hSummary "Task C" to hTask
Send ComAddBar of hoItems hTask "Task" "2/23/2001" "2/27/2001" "K3" Nothing
Set ComExpandItem of hoItems hSummary to True
Send ComDefineSummaryBars of hoItems hSummary "" -1 "<*>"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1849
|
It appears that I can not use the ItemFromPoint property in my environment. What else I can do
// Occurs when the user moves the mouse.
Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComMouseMove llButton llShift llX llY
Showln (ComExecuteTemplate(Self,"Dim c, hit; ItemFromPoint(-1,-1, c, hit )"))
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Default" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComPartialCheck of hoColumn to True
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Root 1" to h
Get ComInsertItem of hoItems h "Child 1" to Nothing
Get ComInsertItem of hoItems h "Child 2" to Nothing
Set ComExpandItem of hoItems h to True
Get ComAddItem of hoItems "Root 2" to h
Get ComInsertItem of hoItems h "Child 1" to Nothing
Get ComInsertItem of hoItems h "Child 2" to Nothing
Set ComExpandItem of hoItems h to True
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1848
|
How can I change the color for selected links (ebn)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Set ComRenderType of hoAppearance to -2
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAEGg4BNkMQAAYAQGKIYBkAKBQAGaAoDDYNQwQwAAwjIKEEwsACEIrjKCVIgkHYJRjGEZxMAsEwjAoaQChEZRUhEMgxDDIIxAJIcaw0GSEZwgOQZBiOEYnDANMgzDLMZR7DajYymSA6LiKNo+QjKFB0NLMVRtEIIIzCSCaNomT4DS4NIi2DYcVhhMqBYbtCZZBo2FpZUxXdL0BJMVxbHKYJikW4pVjoAJ+TxccjVDQNJyLQ6rYzuAAKNpuO58RbdGDQHA9KyfLCEcTxYAMbp6X5kaBZVp2VCMRzbTLUIDzPNVCTrNIaJioAaMeiCG5NUzieqRNalLABFjZMIHDbtGynDIJZruW52+CLIZpWbEOiRXr2TxxgGYp5Fie5mAYBgIgSFDrDOIZUmQZYiECXJUjIEQ3lUGgbEIRQcg+Hg8DEFxYFuOR/i+X5znufh/omBgCgCVwjn4BoBmCCAmAqApgkefgMgOYQID4DoELsUgTgUYYIC4F4GGGSAaBuBxhhgfgggUYgog4EYJGIaBJn6ChiBiLgsgkIpoj4J4BCMSJWDaDZjgiZgCEAQCAgA==" to Nothing
Get ComAdd of hoAppearance 2 "CP:1 -2 -2 2 2" to Nothing
Send Destroy to hoAppearance
Set ComDefaultItemHeight to 24
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComNonworkingDays of hoChart to 0
Set ComLinksStyle of hoChart to OLEexLinkSolid
Set ComLinksWidth of hoChart to 2
Set ComSelLinkColor of hoChart to |CI$20000ff
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h1
Get ComAddItem of hoItems "Task 1" to h1
Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "" Nothing
Variant h2
Get ComAddItem of hoItems "Task 2" to h2
Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/4/2001" "" Nothing
Send ComAddLink of hoItems "L1" h1 "" h2 ""
Set ComLink of hoItems "L1" OLEexLinkSelected to True
Variant h3
Get ComAddItem of hoItems "Task 3" to h3
Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/4/2001" "" Nothing
Send ComAddLink of hoItems "L2" h2 "" h3 ""
Get ComSchedulePDM of hoItems 0 "" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1847
|
How can I change the color for selected links (color, no frame)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 24
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComNonworkingDays of hoChart to 0
Set ComLinksStyle of hoChart to OLEexLinkSolid
Set ComLinksWidth of hoChart to 2
Set ComSelLinkColor of hoChart to |CI$7f0000ff
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h1
Get ComAddItem of hoItems "Task 1" to h1
Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "" Nothing
Variant h2
Get ComAddItem of hoItems "Task 2" to h2
Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/4/2001" "" Nothing
Send ComAddLink of hoItems "L1" h1 "" h2 ""
Set ComLink of hoItems "L1" OLEexLinkSelected to True
Variant h3
Get ComAddItem of hoItems "Task 3" to h3
Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/4/2001" "" Nothing
Send ComAddLink of hoItems "L2" h2 "" h3 ""
Get ComSchedulePDM of hoItems 0 "" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1846
|
How can I change the color for selected links (color, frame)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 24
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComNonworkingDays of hoChart to 0
Set ComLinksStyle of hoChart to OLEexLinkSolid
Set ComLinksWidth of hoChart to 2
Set ComSelLinkColor of hoChart to (RGB(255,0,0))
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h1
Get ComAddItem of hoItems "Task 1" to h1
Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "" Nothing
Variant h2
Get ComAddItem of hoItems "Task 2" to h2
Send ComAddBar of hoItems h2 "Task" "1/2/2001" "1/4/2001" "" Nothing
Send ComAddLink of hoItems "L1" h1 "" h2 ""
Set ComLink of hoItems "L1" OLEexLinkSelected to True
Variant h3
Get ComAddItem of hoItems "Task 3" to h3
Send ComAddBar of hoItems h3 "Task" "1/2/2001" "1/4/2001" "" Nothing
Send ComAddLink of hoItems "L2" h2 "" h3 ""
Get ComSchedulePDM of hoItems 0 "" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1845
|
By default, the bar gets selected once the user releases the button of the mouse. Is it possible to change this behavior so the bar gets selected once the user presses the button of the mouse
// Occurs when the user presses a mouse button.
Procedure OnComMouseDown Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComMouseDown llButton llShift llX llY
Variant h
Get ComItemFromPoint -1 -1 c hit to h
Variant v
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Get ComBarFromPoint of hoChart -1 -1 to v
Send Destroy to hoChart
Variant b
Move v to b
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComItemBar of hoItems 0 "<*>" OLEexBarSelected to False
Set ComItemBar of hoItems h b OLEexBarSelected to True
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDefaultItemHeight to 32
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAEGg4BNkMQAAYAQGKIYBkAKBQAGaAoDDYNQwQwAAwjIKEEwsACEIrjKCVIgkHYJRjGEZxMAsEwjAoaQChEZRUhEMgxDDIIxAJIcaw0GSEZwgOQZBiOEYnDANMgzDLMZR7DajYymSA6LiKNo+QjKFB0NLMVRtEIIIzCSCaNomT4DS4NIi2DYcVhhMqBYbtCZZBo2FpZUxXdL0BJMVxbHKYJikW4pVjoAJ+TxccjVDQNJyLQ6rYzuAAKNpuO58RbdGDQHA9KyfLCEcTxYAMbp6X5kaBZVp2VCMRzbTLUIDzPNVCTrNIaJioAaMeiCG5NUzieqRNalLABFjZMIHDbtGynDIJZruW52+CLIZpWbEOiRXr2TxxgGYp5Fie5mAYBgIgSFDrDOIZUmQZYiECXJUjIEQ3lUGgbEIRQcg+Hg8DEFxYFuOR/i+X5znufh/omBgCgCVwjn4BoBmCCAmAqApgkefgMgOYQID4DoELsUgTgUYYIC4F4GGGSAaBuBxhhgfgggUYgog4EYJGIaBJn6ChiBiLgsgkIpoj4J4BCMSJWDaDZjgiZgCEAQCAgA==" to Nothing
Get ComAdd of hoAppearance 2 "CP:1 -2 -2 2 2" to Nothing
Send Destroy to hoAppearance
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Set ComAllowSelectObjects of hoChart1 to OLEexNoSelectObjects
Set ComFirstVisibleDate of hoChart1 to "1/1/2002"
Set ComSelBarColor of hoChart1 to |CI$2000000
Set ComPaneWidth of hoChart1 False to 48
Send Destroy to hoChart1
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Get ComAddItem of hoItems1 "Task" to h
Send ComAddBar of hoItems1 h "Task" "1/2/2002" "1/4/2002" "A" Nothing
Send ComAddBar of hoItems1 h "Task" "1/6/2002" "1/10/2002" "B" Nothing
Send ComAddBar of hoItems1 h "Task" "1/11/2002" "1/14/2002" "C" Nothing
Set ComItemBar of hoItems1 h "B" OLEexBarSelected to True
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1844
|
How can I change the bar's color (sample 3, ebn, individual, global)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Set ComRenderType of hoAppearance to -2
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABN0GACAADACAxRDAMgBQKAAzQFAYahuGSGAAGMYxQgmFgAQhFcZQSKUOQTDKMIziYBYJhEMQyDAAUIjOKsIhkGYcZAGQBJCjWGodQLOEgwHIERQjEyUJAGGQIHhyPYbUbGUpQHKkeRtGqgBgoKhKEouNYgAbGYIwTRsdyfDSXBpEWwbDgkNQwWTDNoRDIUQStCysaYjOpnfrUAJ1P7FdQ1NJkXRhGSSK7maapaiCSZ6STCMj1FhVKSNJ7DQKhGpgKh/ApgYpQOK4fLNXyRBK4QAyKA6bgPFZOZbFViaXY1V5bNKrcjhHQwAyHJ4XXRdV4YRAkUT4GqiJKGSYcQhuXZWbRqO6ABhef6DRThc6jKpFHIE4llEcojHqSZNgoIxnlgd5thsLREleL43gsYZ9BkaAYkMAgAm+CxGDWWAtiKCRfjcdRgHoHYnicUwgAIEIREAaQYkcQZUHIGRUDQJBOEYRAhDYCxGgMZAkCgdYQhaXQIAYERwQuahXggdgeG6VZ4H4IhdiIGIOB8YIiGiHZZgqYpGF4KYHiKCI+CAU5jCiTQ2g0YhEFyax4gABAEIC" to Nothing
Get ComAdd of hoAppearance 2 "gBFLBCJwBAEHhEJAAEhABU0IQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjAKMEwsACEIrjKCRShyCYZRhGcTAJBMIhiGQYAChEZxVhEMgzDjIAxSJAcQRFESaAABGCQGh+N4/S4NIi0CIsZQjCaiZ7pKA5bgMCo+UrNMixZQVCSOGChYRpCaZWpGGodQRUFbVHAlKypJKCKrEWSrDhuYAAW7XM7yBS1TzVNSuLZtaLqSroAJ1WTWMB0Ra8NzZEKfaZACj4arKejrRDCMAggI=" to Nothing
Send Destroy to hoAppearance
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarHAlignCaption to 18
Set ComColor of hoBar to |CI$1000000
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComItem of hoBars1 "Summary" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComDef of hoBar1 OLEexBarHAlignCaption to 18
Set ComColor of hoBar1 to |CI$2000000
Send Destroy to hoBar1
Send Destroy to hoBars1
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummaryJ
Get ComAddItem of hoItems "Summary A" to hSummaryJ
Send ComAddBar of hoItems hSummaryJ "Summary" "1/2/2001" "1/2/2001" "J" Nothing
Variant hTaskJ
Get ComInsertItem of hoItems hSummaryJ "Task A.1" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/2/2001" "1/5/2001" "J1" Nothing
Get ComInsertItem of hoItems hSummaryJ "Task A.2" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/4/2001" "1/8/2001" "J2" Nothing
Send ComDefineSummaryBars of hoItems hSummaryJ "J" -1 "<*>"
Variant hSummaryK
Get ComAddItem of hoItems "Summary B" to hSummaryK
Send ComAddBar of hoItems hSummaryK "Summary" "1/2/2001" "1/2/2001" "K" Nothing
Variant hTaskK
Get ComInsertItem of hoItems hSummaryK "Task B.1" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummaryK "Task B.2" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Send ComDefineSummaryBars of hoItems hSummaryK "K" -1 "<*>"
Set ComItemBar of hoItems 0 "<K*>" OLEexBarColor to 255
Set ComExpandItem of hoItems 0 to True
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1843
|
How can I change the bar's color (sample 2, global)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarHAlignCaption to 18
Set ComColor of hoBar to (RGB(255,0,0))
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComItem of hoBars1 "Summary" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComDef of hoBar1 OLEexBarHAlignCaption to 18
Set ComColor of hoBar1 to (RGB(255,0,0))
Set ComStartColor of hoBar1 to (ComColor(hoBar1))
Set ComEndColor of hoBar1 to (ComColor(hoBar1))
Send Destroy to hoBar1
Send Destroy to hoBars1
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummaryJ
Get ComAddItem of hoItems "Summary A" to hSummaryJ
Send ComAddBar of hoItems hSummaryJ "Summary" "1/2/2001" "1/2/2001" "J" Nothing
Variant hTaskJ
Get ComInsertItem of hoItems hSummaryJ "Task A.1" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/2/2001" "1/5/2001" "J1" Nothing
Get ComInsertItem of hoItems hSummaryJ "Task A.2" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/4/2001" "1/8/2001" "J2" Nothing
Send ComDefineSummaryBars of hoItems hSummaryJ "J" -1 "<*>"
Variant hSummaryK
Get ComAddItem of hoItems "Summary B" to hSummaryK
Send ComAddBar of hoItems hSummaryK "Summary" "1/2/2001" "1/2/2001" "K" Nothing
Variant hTaskK
Get ComInsertItem of hoItems hSummaryK "Task B.1" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummaryK "Task B.2" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Send ComDefineSummaryBars of hoItems hSummaryK "K" -1 "<*>"
Set ComExpandItem of hoItems 0 to True
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1842
|
How can I change the bar's color (sample 1, individual)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComDef of hoBar OLEexBarHAlignCaption to 18
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComItem of hoBars1 "Summary" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComDef of hoBar1 OLEexBarHAlignCaption to 18
Send Destroy to hoBar1
Send Destroy to hoBars1
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummaryJ
Get ComAddItem of hoItems "Summary A" to hSummaryJ
Send ComAddBar of hoItems hSummaryJ "Summary" "1/2/2001" "1/2/2001" "J" " (default)"
Variant hTaskJ
Get ComInsertItem of hoItems hSummaryJ "Task A.1" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/2/2001" "1/5/2001" "J1" "(default)"
Get ComInsertItem of hoItems hSummaryJ "Task A.2" to hTaskJ
Send ComAddBar of hoItems hTaskJ "Task" "1/4/2001" "1/8/2001" "J2" "(default)"
Send ComDefineSummaryBars of hoItems hSummaryJ "J" -1 "<*>"
Variant hSummaryK
Get ComAddItem of hoItems "Summary B" to hSummaryK
Send ComAddBar of hoItems hSummaryK "Summary" "1/2/2001" "1/2/2001" "K" Nothing
Variant hTaskK
Get ComInsertItem of hoItems hSummaryK "Task B.1" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummaryK "Task B.2" to hTaskK
Send ComAddBar of hoItems hTaskK "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Send ComDefineSummaryBars of hoItems hSummaryK "K" -1 "<*>"
Set ComItemBar of hoItems hSummaryK "" OLEexBarColor to 255
Set ComItemBar of hoItems 0 "<K*>" OLEexBarColor to 255
Set ComExpandItem of hoItems 0 to True
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1841
|
How do I make the control read-only (method 2)
// Occurs just before editing the focused cell.
Procedure OnComEdit HITEM llItem Integer llColIndex Boolean llCancel
Forward Send OnComEdit llItem llColIndex llCancel
Move True to Cancel
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Editor" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Variant voEditor
Get ComEditor of hoColumn to voEditor
Handle hoEditor
Get Create (RefClass(cComEditor)) to hoEditor
Set pvComObject of hoEditor to voEditor
Set ComEditType of hoEditor to OLECheckListType
Send ComAddItem of hoEditor 1 "One" Nothing
Send ComAddItem of hoEditor 2 "Two" Nothing
Send Destroy to hoEditor
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "Check" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Variant voEditor1
Get ComEditor of hoColumn1 to voEditor1
Handle hoEditor1
Get Create (RefClass(cComEditor)) to hoEditor1
Set pvComObject of hoEditor1 to voEditor1
Set ComEditType of hoEditor1 to OLECheckValueType
Set ComOption of hoEditor1 OLEexCheckValue1 to 2
Send Destroy to hoEditor1
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellValue of hoItems (ComAddItem(hoItems,1)) 1 to 0
Set ComCellValue of hoItems (ComAddItem(hoItems,2)) 1 to 1
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1840
|
How do I make the control read-only (method 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComReadOnly to OLEexReadOnly
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Editor" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Variant voEditor
Get ComEditor of hoColumn to voEditor
Handle hoEditor
Get Create (RefClass(cComEditor)) to hoEditor
Set pvComObject of hoEditor to voEditor
Set ComEditType of hoEditor to OLECheckListType
Send ComAddItem of hoEditor 1 "One" Nothing
Send ComAddItem of hoEditor 2 "Two" Nothing
Send Destroy to hoEditor
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "Check" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Variant voEditor1
Get ComEditor of hoColumn1 to voEditor1
Handle hoEditor1
Get Create (RefClass(cComEditor)) to hoEditor1
Set pvComObject of hoEditor1 to voEditor1
Set ComEditType of hoEditor1 to OLECheckValueType
Set ComOption of hoEditor1 OLEexCheckValue1 to 2
Send Destroy to hoEditor1
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellValue of hoItems (ComAddItem(hoItems,1)) 1 to 0
Set ComCellValue of hoItems (ComAddItem(hoItems,2)) 1 to 1
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1839
|
The ReadOnly property does not prevent changing the column's check-box (sample 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComShowFocusRect to False
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "C1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 18
Variant voEditor
Get ComEditor of hoColumn to voEditor
Handle hoEditor
Get Create (RefClass(cComEditor)) to hoEditor
Set pvComObject of hoEditor to voEditor
Set ComEditType of hoEditor to OLECheckValueType
Send Destroy to hoEditor
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Get ComAdd of hoColumns1 "C2" to Nothing
Send Destroy to hoColumns1
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellValue of hoItems (ComAddItem(hoItems,0)) 1 to "Item 1"
Set ComCellValue of hoItems (ComAddItem(hoItems,-1)) 1 to "Item 2"
Set ComCellValue of hoItems (ComAddItem(hoItems,0)) 1 to "Item 3"
Send Destroy to hoItems
Set ComReadOnly to True
Variant voColumns2
Get ComColumns to voColumns2
Handle hoColumns2
Get Create (RefClass(cComColumns)) to hoColumns2
Set pvComObject of hoColumns2 to voColumns2
Variant voColumn1
Get ComItem of hoColumns2 0 to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Variant voEditor1
Get ComEditor of hoColumn1 to voEditor1
Handle hoEditor1
Get Create (RefClass(cComEditor)) to hoEditor1
Set pvComObject of hoEditor1 to voEditor1
Set ComOption of hoEditor1 OLEexCheckValue2 to 2
Send Destroy to hoEditor1
Send Destroy to hoColumn1
Send Destroy to hoColumns2
Send ComEndUpdate
End_Procedure
|
|
1838
|
The ReadOnly property does not prevent changing the column's check-box (sample 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComShowFocusRect to False
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "C1" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 18
Variant voEditor
Get ComEditor of hoColumn to voEditor
Handle hoEditor
Get Create (RefClass(cComEditor)) to hoEditor
Set pvComObject of hoEditor to voEditor
Set ComEditType of hoEditor to OLECheckValueType
Set ComOption of hoEditor OLEexCheckValue2 to 1
Send Destroy to hoEditor
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Get ComAdd of hoColumns1 "C2" to Nothing
Send Destroy to hoColumns1
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellValue of hoItems (ComAddItem(hoItems,0)) 1 to "Item 1"
Set ComCellValue of hoItems (ComAddItem(hoItems,-1)) 1 to "Item 2"
Set ComCellValue of hoItems (ComAddItem(hoItems,0)) 1 to "Item 3"
Send Destroy to hoItems
Set ComReadOnly to True
Send ComEndUpdate
End_Procedure
|
|
1837
|
How can I change the visual appearance of the control's split bar (sample 3)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Default" to Nothing
Send Destroy to hoColumns
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABPsIQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjAKMEwsACEIrjKCRShyCYZRrGUQxCKIZhzEgYRokAYYRDIMg5SBIETzFIMCQ9AaaJpieRJGiiKoJSxHErgFD8QxzEKOZqnCapViAMpOAZQAwDAIoWhpKKBRhqOpRUhaID/WAAFCUZK4ASTDCyLRgNy4lACgI" to Nothing
Get ComAdd of hoAppearance 2 "gBFLBCJwBAEHhEJAAEhABPkIQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjAKMEwsACEIrjKCRShyCYZRrGUQxCKIZhzEgYRoiEYhXDiIAxARHcgyBIMPQJGSaZpkSRpIiqHItS6BM4RVKkcw7G6BaJnGJpADKTQGQiMIwDAIoWhpKCBaiqSpqMglf5fg6pOJqHACZZKWLNLpxDBMAkBA=" to Nothing
Get ComAdd of hoAppearance 3 "gBFLBCJwBAEHhEJAAEhABUUIQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjAKMEwsACEIrjKCRShyCYZRrGQCwTCIYhmHKSRhGSIRSDcOIgDCBEbyDIEQw9AiZZqmaRZHimK4cS5MEhwHKsLSLGyOZwoSapbgmJooU5KUwSYKQcxBI6laYpIAKJhiWobTxUEBwMKlJw5KoBJxjKqIbp2XZsUxIAxXEA1HBgGASRZGS5bDreeQ0UZCL74GAFUy/Liba6weqnLhGCYBgIA==" to Nothing
Send Destroy to hoAppearance
Set ComBackground OLEexSplitBar to |CI$1808080
Set ComBackground OLEexHSplitBar to |CI$2808080
Set ComBackground OLEexCSplitBar to |CI$3010101
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 64
Set ComHistogramVisible of hoChart to True
Set ComHistogramHeight of hoChart to 64
Set ComOverviewHeight of hoChart to 48
Set ComOverviewVisible of hoChart to OLEexOverviewShowAll
Send Destroy to hoChart
Send ComEndUpdate
End_Procedure
|
|
1836
|
How can I change the color for the control's split bar (sample 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Default" to Nothing
Send Destroy to hoColumns
Set ComBackground OLEexSplitBar to (RGB(190,190,190))
Set ComBackground OLEexHSplitBar to (RGB(128,128,128))
Set ComBackground OLEexCSplitBar to (RGB(0,0,1))
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 64
Set ComHistogramVisible of hoChart to True
Set ComHistogramHeight of hoChart to 64
Set ComOverviewHeight of hoChart to 48
Set ComOverviewVisible of hoChart to OLEexOverviewShowAll
Send Destroy to hoChart
Send ComEndUpdate
End_Procedure
|
|
1835
|
How do I highlight a bar with an icon, exclamation mark or some warning sign, without using exBarCaption, exBarExtraCaption which I've already use for something else ( sample 2 )
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "12/26/2000"
Set ComPaneWidth of hoChart False to 128
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems "" to Nothing
Variant h
Get ComAddItem of hoItems "Item" to h
Get ComAddItem of hoItems "" to Nothing
Send ComAddBar of hoItems h "Task" "1/1/2001" "1/13/2001" "A" Nothing
Send Destroy to hoItems
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Variant voNotes
Get ComNotes of hoChart1 to voNotes
Handle hoNotes
Get Create (RefClass(cComNotes)) to hoNotes
Set pvComObject of hoNotes to voNotes
Variant vItem
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Get ComItemByIndex of hoItems1 1 to vItem
Send Destroy to hoItems1
Variant voNote
Get ComAdd of hoNotes "Attention" vItem "A" " <font ;11>! " to voNote
Handle hoNote
Get Create (RefClass(cComNote)) to hoNote
Set pvComObject of hoNote to voNote
Set ComRelativePosition of hoNote to 0.5
Set ComShowLink of hoNote to OLEexNoteLinkHidden
Set ComPartVOffset of hoNote OLEexNoteEnd to 0
Set ComPartShadow of hoNote OLEexNoteEnd to False
Set ComPartBackColor of hoNote OLEexNoteEnd to (RGB(255,255,0))
Send Destroy to hoNote
Send Destroy to hoNotes
Send Destroy to hoChart1
Send ComEndUpdate
End_Procedure
|
|
1834
|
How do I highlight a bar with an icon, exclamation mark or some warning sign, without using exBarCaption, exBarExtraCaption which I've already use for something else ( sample 1 )
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "12/26/2000"
Set ComPaneWidth of hoChart False to 128
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems "" to Nothing
Variant h
Get ComAddItem of hoItems "Item" to h
Get ComAddItem of hoItems "" to Nothing
Send ComAddBar of hoItems h "Task" "1/1/2001" "1/13/2001" "A" Nothing
Set ComItemBar of hoItems h "A" OLEexBarBackgroundExt to "[text=`<bgcolor=FFFF00><font ;11> ! `,align=0x11]"
Set ComItemBar of hoItems h "A" OLEexBarBackgroundExtInflate to 8
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1833
|
How do I get the "Summary" bar being shown in the control's histogram (sample 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABU0IQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjAKMEwsACEIrjKCRShyCYZRhGcTAJBMIhiGQYAChEZxVhEMgzDjIAxSJAcQRFESaAABGCQGh+N4/S4NIi0CIsZQjCaiZ7pKA5bgMCo+UrNMixZQVCSOGChYRpCaZWpGGodQRUFbVHAlKypJKCKrEWSrDhuYAAW7XM7yBS1TzVNSuLZtaLqSroAJ1WTWMB0Ra8NzZEKfaZACj4arKejrRDCMAggI=" to Nothing
Send Destroy to hoAppearance
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComHistogramVisible of hoChart to True
Set ComHistogramHeight of hoChart to 64
Set ComHistogramView of hoChart to (OLEexHistogramNoGrouping + OLEexHistogramAllItems)
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHistogramPattern of hoBar to (ComPattern(hoBar))
Set ComHistogramType of hoBar to OLEexHistCumulative
Set ComHistogramCumulativeOriginalColorBars of hoBar to OLEexKeepOriginalColor
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummary
Get ComAddItem of hoItems "Summary" to hSummary
Send ComAddBar of hoItems hSummary "Task" "1/2/2001" "1/2/2001" "" Nothing
Set ComItemBar of hoItems hSummary "" OLEexBarColor to 16777216
Variant hTask
Get ComInsertItem of hoItems hSummary "Task A" to hTask
Send ComAddBar of hoItems hTask "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummary "Task B" to hTask
Send ComAddBar of hoItems hTask "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Get ComInsertItem of hoItems hSummary "Task C" to hTask
Send ComAddBar of hoItems hTask "Task" "1/12/2001" "1/17/2001" "K3" Nothing
Set ComExpandItem of hoItems hSummary to True
Send ComDefineSummaryBars of hoItems hSummary "" -1 "<*>"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1832
|
How do I get the "Summary" bar being shown in the control's histogram (sample 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABU0IQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjAKMEwsACEIrjKCRShyCYZRhGcTAJBMIhiGQYAChEZxVhEMgzDjIAxSJAcQRFESaAABGCQGh+N4/S4NIi0CIsZQjCaiZ7pKA5bgMCo+UrNMixZQVCSOGChYRpCaZWpGGodQRUFbVHAlKypJKCKrEWSrDhuYAAW7XM7yBS1TzVNSuLZtaLqSroAJ1WTWMB0Ra8NzZEKfaZACj4arKejrRDCMAggI=" to Nothing
Send Destroy to hoAppearance
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComHistogramVisible of hoChart to True
Set ComHistogramHeight of hoChart to 64
Set ComHistogramView of hoChart to (OLEexHistogramNoGrouping + OLEexHistogramAllItems)
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHistogramPattern of hoBar to (ComPattern(hoBar))
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComItem of hoBars1 "Summary" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComColor of hoBar1 to |CI$1000000
Set ComHistogramColor of hoBar1 to (RGB(0,0,1))
Set ComHistogramPattern of hoBar1 to OLEexPatternBDiagonal
Send Destroy to hoBar1
Send Destroy to hoBars1
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummary
Get ComAddItem of hoItems "Summary" to hSummary
Send ComAddBar of hoItems hSummary "Summary" "1/2/2001" "1/2/2001" "" Nothing
Variant hTask
Get ComInsertItem of hoItems hSummary "Task A" to hTask
Send ComAddBar of hoItems hTask "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummary "Task B" to hTask
Send ComAddBar of hoItems hTask "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Get ComInsertItem of hoItems hSummary "Task C" to hTask
Send ComAddBar of hoItems hTask "Task" "1/12/2001" "1/17/2001" "K3" Nothing
Set ComExpandItem of hoItems hSummary to True
Send ComDefineSummaryBars of hoItems hSummary "" -1 "<*>"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1831
|
How can I temporarily/programmatically hide the control's tooltip
// Fired when right mouse button is clicked
Procedure OnComRClick
Forward Send OnComRClick
Variant nToolTipDelay
Get ComToolTipDelay to nToolTipDelay
Set ComToolTipDelay to 0
Set ComToolTipDelay to nToolTipDelay
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Column w/h tooltip..." to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComToolTip of hoColumn to "This is a bit of text that's shown when the cursor hovers the column.<br><br><sha ;;0><c>Right-Click to hide it</sha>"
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstWeekDay of hoChart to (ComLocFirstWeekDay(hoChart))
Set ComMonthNames of hoChart to (ComLocMonthNames(hoChart))
Set ComWeekDays of hoChart to (ComLocWeekDays(hoChart))
Set ComAMPM of hoChart to (ComLocAMPM(hoChart))
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 128
Set ComUnitScale of hoChart to OLEexDay
Send Destroy to hoChart
Set ComHeaderAppearance to OLEFlat
Set ComBackColorLevelHeader to (ComBackColor(Self))
Send ComEndUpdate
End_Procedure
|
|
1830
|
Is it possible to find out the handle of the item, giving the key of the bar only
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDebug to True
Set ComDefaultItemHeight to 32
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 64
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHeight of hoBar to 16
Send Destroy to hoBar
Send Destroy to hoBars
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComShowLinks of hoChart to OLEexShowExtendedLinks
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 1")) "Task" "1/2/2001" "1/4/2001" "K1" Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Task 2")) "Task" "1/5/2001" "1/7/2001" "K2" Nothing
Set ComItemBold of hoItems (ComItemBar(hoItems,0,"K2",OLEexBarParent)) to True
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1829
|
How can I programmatically add a link between two bars, knowing the keys of these bars only
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDebug to True
Set ComDefaultItemHeight to 32
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 64
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHeight of hoBar to 16
Send Destroy to hoBar
Send Destroy to hoBars
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComShowLinks of hoChart to OLEexShowExtendedLinks
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h1
Get ComAddItem of hoItems "Task 1" to h1
Send ComAddBar of hoItems h1 "Task" "1/2/2001" "1/4/2001" "K1" Nothing
Variant h2
Get ComAddItem of hoItems "Task 2" to h2
Send ComAddBar of hoItems h2 "Task" "1/5/2001" "1/7/2001" "AK2" Nothing
Variant h3
Get ComAddItem of hoItems "Task 3" to h3
Send ComAddBar of hoItems h3 "Task" "1/5/2001" "1/7/2001" "AK3" Nothing
Send ComAddLink of hoItems "Link1" 0 "K1" 0 "AK2"
Send ComAddLink of hoItems "Link2" 0 "K1" 0 "<A?3>"
Send ComAddLink of hoItems "Link3" 0 "<*2>" 0 "AK3"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1828
|
I'm trying to use automatic numbering of the outline. How can I have A, B, C for root items, 1, 2, 3 for the sub-items, and a, b, c for sub-sub-items (sample 3)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComLinesAtRoot to OLEexLinesAtRoot
Set ComDrawGridLines to OLEexRowLines
Set ComAutoDrag to OLEexAutoDragPositionAny
Set ComHasLines to OLEexSolidLine
Set ComIndent to 16
Set ComMarkSearchColumn to False
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueFormat to 1
Set ComFormatColumn of hoColumn to "((1:=(0 :=(1 rpos '.|A-Z||a-z|')) rfind `.`) < 0 ? `<b>` + =:0 + `` : (=:0 mid (1 + 1 + =:1) ) + `)` ) + ` ` + value"
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child" to Nothing
Variant hChild
Get ComInsertItem of hoItems h "Child" to hChild
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to Nothing
Set ComExpandItem of hoItems 0 to True
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to hChild
Set ComCellState of hoItems hChild 0 to 1
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1827
|
I'm trying to use automatic numbering of the outline. How can I have A, B, C for root items, 1, 2, 3 for the sub-items, and a, b, c for sub-sub-items (sample 2)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComLinesAtRoot to OLEexLinesAtRoot
Set ComGridLineColor to (RGB(190,190,190))
Set ComDrawGridLines to OLEexRowLines
Set ComAutoDrag to OLEexAutoDragPositionAny
Set ComHasLines to OLEexSolidLine
Set ComIndent to 16
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Default" to Nothing
Variant voColumn
Get ComAdd of hoColumns "" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueFormat to 1
Set ComDef of hoColumn OLEexCellPaddingRight to 4
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 36
Set ComPosition of hoColumn to 0
Set ComFormatColumn of hoColumn to "(1:=(0 :=(1 rpos '.|A-Z||a-z|')) rfind `.`) < 0 ? `<b>` + =:0 : (`............` left 2 * (=:0 count `.`)) + (=:0 mid (1 + 1 + =:1) ) "
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child" to Nothing
Variant hChild
Get ComInsertItem of hoItems h "Child" to hChild
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to Nothing
Set ComExpandItem of hoItems 0 to True
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to hChild
Set ComCellState of hoItems hChild 0 to 1
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1826
|
I'm trying to use automatic numbering of the outline. How can I have A, B, C for root items, 1, 2, 3 for the sub-items, and a, b, c for sub-sub-items (sample 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComLinesAtRoot to OLEexLinesAtRoot
Set ComDrawGridLines to OLEexRowLines
Set ComAutoDrag to OLEexAutoDragPositionAny
Set ComHasLines to OLEexSolidLine
Set ComIndent to 16
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Default" to Nothing
Variant voColumn
Get ComAdd of hoColumns "" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueFormat to 1
Set ComDef of hoColumn OLEexCellPaddingRight to 4
Set ComAlignment of hoColumn to OLERightAlignment
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 24
Set ComPosition of hoColumn to 0
Set ComFormatColumn of hoColumn to "(1:=(0 :=(1 rpos '.|A-Z||a-z|')) rfind `.`) < 0 ? `<b>` + =:0 : `<i>` + (=:0 mid (1 + 1 + =:1) ) "
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child" to Nothing
Variant hChild
Get ComInsertItem of hoItems h "Child" to hChild
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to Nothing
Set ComExpandItem of hoItems 0 to True
Get ComAddItem of hoItems "Root" to h
Get ComInsertItem of hoItems h "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to hChild
Set ComCellState of hoItems hChild 0 to 1
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems hChild "Child" to Nothing
Get ComInsertItem of hoItems h "Child" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1825
|
How can I programmatically group by columns, without having the control's sort bar visible
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Set ComColumnAutoResize to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "Orders" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenStatic OLEadLockOptimistic Nothing
Set ComDataSource to rs
Set ComSortBarHeight to 0
Set ComSortBarVisible to True
Set ComSortBarCaption to "Drag a <b>column</b> header here to group by that column."
Set ComAllowGroupBy to True
Set ComLayout to "multiplesort="C1:2""
Send ComEndUpdate
End_Procedure
|
|
1824
|
How do I perform my own sort
// Fired when the control sorts a column.
Procedure OnComSort
Forward Send OnComSort
Showln "Sort"
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComItemPosition of hoItems (ComItemByIndex(hoItems,1)) to 0
Set ComItemPosition of hoItems (ComItemByIndex(hoItems,0)) to 1
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComSingleSort to False
Set ComSortOnClick to OLEexUserSort
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Index" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComFormatColumn of hoColumn to "0 index ``"
Send Destroy to hoColumn
Get ComAdd of hoColumns "Data 1" to Nothing
Get ComAdd of hoColumns "Data 2" to Nothing
Send Destroy to hoColumns
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Variant h
Get ComAddItem of hoItems1 0 to h
Set ComCellValue of hoItems1 h 1 to 2
Set ComCellValue of hoItems1 h 2 to 3
Get ComAddItem of hoItems1 4 to h
Set ComCellValue of hoItems1 h 1 to 5
Set ComCellValue of hoItems1 h 2 to 6
Get ComAddItem of hoItems1 7 to h
Set ComCellValue of hoItems1 h 1 to 8
Set ComCellValue of hoItems1 h 2 to 9
Send Destroy to hoItems1
Set ComLayout to "multiplesort="C1:1 C2:2""
Send ComEndUpdate
End_Procedure
|
|
1823
|
Is it possible to have a different alignment for parts of the cell's caption
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to True
Send Destroy to hoChart
Set ComTreeColumnIndex to -1
Set ComDrawGridLines to OLEexRowLines
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Default" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellHAlignment of hoItems (ComAddItem(hoItems,"all-left")) 0 to OLELeftAlignment
Set ComCellHAlignment of hoItems (ComAddItem(hoItems,"all-center")) 0 to OLECenterAlignment
Set ComCellHAlignment of hoItems (ComAddItem(hoItems,"all-right")) 0 to OLERightAlignment
Variant h
Get ComAddItem of hoItems "left<c>center<r>right" to h
Set ComCellValueFormat of hoItems h 0 to OLEexHTML
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1822
|
I have a column with Def(exCellSingleLine) property on False, word-wrapping, and I am wondering if possible to update the column's content while user is resizing it
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "MultipleLine" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComWidth of hoColumn to 32
Set ComDef of hoColumn OLEexCellSingleLine to False
Set ComDef of hoColumn OLEexColumnResizeContiguously to True
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "SingleLine" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellSingleLine to False
Send Destroy to hoColumn1
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellValue of hoItems (ComAddItem(hoItems,"This is a bit of long text that should break the line")) 1 to "This is a bit of long text that should break the line"
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1821
|
Is there an other way to detect if a bar is overlapping any other bar
// Occurs when a bar is moving or resizing.
Procedure OnComBarResizing HITEM llItem Variant llKey
Forward Send OnComBarResizing llItem llKey
Send ComRefresh
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexVLines
Set ComHeaderAppearance to OLEEtched
Set ComBackColorLevelHeader to (ComBackColor(Self))
Set ComDefaultItemHeight to 22
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn
Get ComAdd of hoColumns1 "Intersect / Count" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellValueToItemBarKey to "A"
Set ComDef of hoColumn OLEexCellValueToItemBarProperty to 521
Set ComLevelKey of hoColumn to 1
Send Destroy to hoColumn
Send Destroy to hoColumns1
Variant voColumns2
Get ComColumns to voColumns2
Handle hoColumns2
Get Create (RefClass(cComColumns)) to hoColumns2
Set pvComObject of hoColumns2 to voColumns2
Variant voColumn1
Get ComAdd of hoColumns2 " / With" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComDef of hoColumn1 OLEexCellValueToItemBarKey to "A"
Set ComDef of hoColumn1 OLEexCellValueToItemBarProperty to 520
Set ComLevelKey of hoColumn1 to 1
Send Destroy to hoColumn1
Send Destroy to hoColumns2
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComAllowCellValueToItemBar of hoItems to True
Send Destroy to hoItems
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 148
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComOverlaidType of hoBar to OLEexOverlaidBarsOffset
Set ComOverlaidGroup of hoBar to "TaskB"
Set ComDef of hoBar OLEexBarHAlignCaption to 16
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComAdd of hoBars1 "TaskB" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComPattern of hoBar1 to OLEexPatternBDiagonal
Set ComDef of hoBar1 OLEexBarHAlignCaption to 18
Send Destroy to hoBar1
Send Destroy to hoBars1
Send Destroy to hoChart
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Variant h
Get ComAddItem of hoItems1 "A" to h
Send ComAddBar of hoItems1 h "Task" "1/2/2001" "1/4/2001" "A" "A"
Send ComAddBar of hoItems1 h "TaskB" "1/3/2001" "1/5/2001" "B" "B"
Get ComAddItem of hoItems1 "A" to h
Send ComAddBar of hoItems1 h "Task" "1/6/2001" "1/9/2001" "A" "A"
Send ComAddBar of hoItems1 h "TaskB" "1/10/2001" "1/13/2001" "B" "B"
Get ComAddItem of hoItems1 "A" to h
Send ComAddBar of hoItems1 h "TaskB" "1/6/2001" "1/9/2001" "B1" "B1"
Send ComAddBar of hoItems1 h "Task" "1/10/2001" "1/13/2001" "A" "A"
Send ComAddBar of hoItems1 h "TaskB" "1/10/2001" "1/13/2001" "B2" "B2"
Get ComAddItem of hoItems1 "A" to h
Send ComAddBar of hoItems1 h "Task" "1/8/2001" "1/11/2001" "B1" "B1"
Send ComAddBar of hoItems1 h "Task" "1/10/2001" "1/13/2001" "A" "A"
Send ComAddBar of hoItems1 h "Task" "1/12/2001" "1/15/2001" "B2" "B2"
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1820
|
How can I get the absolute position of an item
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems llItem "Task" "1/2/2017" "1/5/2017" Nothing Nothing
Send Destroy to hoItems
End_Procedure
// Occurs when the user moves the mouse.
Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComMouseMove llButton llShift llX llY
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Variant vItem
Get ComItemFromPoint -1 -1 c hit to vItem
Showln (ComCellCaption(hoItems1,vItem,"Position"))
Send Destroy to hoItems1
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2017"
Send Destroy to hoChart
Set ComBackColorLevelHeader to (ComBackColor(Self))
Set ComBackColorAlternate to (RGB(240,240,240))
Set ComLinesAtRoot to OLEexLinesAtRoot
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Def" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDisplayFilterButton of hoColumn to True
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems2
Get ComItems to voItems2
Handle hoItems2
Get Create (RefClass(cComItems)) to hoItems2
Set pvComObject of hoItems2 to voItems2
Variant h
Get ComAddItem of hoItems2 "Root" to h
Get ComInsertItem of hoItems2 (ComInsertItem(hoItems2,h,"Child 1")) "Sub-Child 1" to Nothing
Get ComInsertItem of hoItems2 (ComInsertItem(hoItems2,h,"Child 2")) "Sub-Child 2" to Nothing
Send Destroy to hoItems2
Send ComPutItems (ComGetItems(Self,-1)) Nothing
Send ComPutItems (ComGetItems(Self,-1)) Nothing
Send ComPutItems (ComGetItems(Self,-1)) Nothing
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "Position" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComFormatColumn of hoColumn1 to "1 apos ``"
Set ComVisible of hoColumn1 to False
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Send ComEndUpdate
End_Procedure
|
|
1819
|
How do I sort the index column as numeric (Method 2)
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Set ComCellData of hoItems llItem 1 to (ComCellCaption(hoItems,llItem,1))
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComDrawGridLines to OLEexAllLines
Set ComColumnAutoResize to True
Set ComShowFocusRect to False
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Next" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDef of hoColumn OLEexCellPaddingLeft to 4
Set ComDef of hoColumn OLEexHeaderPaddingLeft to 4
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "Index" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComAllowSizing of hoColumn1 to False
Set ComWidth of hoColumn1 to 48
Set ComFormatColumn of hoColumn1 to "(((0 := (1 index ``)) mod 3) case ( default: ``; 0 : `<r><fgcolor=B0B0B0>`; 1: ``; 2 : `<c><fgcolor=808080>` )) + str(=:0)"
Set ComDef of hoColumn1 OLEexCellValueFormat to 1
Set ComSortType of hoColumn1 to OLESortUserData
Set ComPosition of hoColumn1 to 0
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Get ComAddItem of hoItems1 "Item 1" to Nothing
Get ComAddItem of hoItems1 "Item 2" to Nothing
Get ComAddItem of hoItems1 "Item 3" to Nothing
Get ComAddItem of hoItems1 "Item 4" to Nothing
Get ComAddItem of hoItems1 "Item 5" to Nothing
Get ComAddItem of hoItems1 "Item 6" to Nothing
Get ComAddItem of hoItems1 "Item 7" to Nothing
Get ComAddItem of hoItems1 "Item 8" to Nothing
Get ComAddItem of hoItems1 "Item 9" to Nothing
Get ComAddItem of hoItems1 "Item 10" to Nothing
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1818
|
How do I sort the index column as numeric (Method 1)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Sort Index As String (Default)" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComFormatColumn of hoColumn to "1 index ``"
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "Sort Index As Numeric" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComComputedField of hoColumn1 to "%C0"
Set ComSortType of hoColumn1 to OLESortNumeric
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1817
|
How can I put icons/images into buttons
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComColumnAutoResize to True
Send ComImages "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "C+B" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 48
Set ComFormatColumn of hoColumn to "` <img>` + ( 1 + (1 index ``) mod 3 ) + `</img> `"
Set ComDef of hoColumn OLEexCellValueFormat to 1
Set ComDef of hoColumn OLEexCellHasCheckBox to True
Set ComDef of hoColumn OLEexCellHasButton to True
Set ComDef of hoColumn OLEexCellButtonAutoWidth to True
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Get ComAdd of hoColumns1 "" to Nothing
Send Destroy to hoColumns1
Set ComDrawGridLines to OLEexVLines
Set ComDefaultItemHeight to 20
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1816
|
Is it possible to have a CheckBox and Button TOGETHER on all cells in a column
// Occurs when user clicks on the cell's button.
Procedure OnComButtonClick HITEM llItem Integer llColIndex Variant llKey
Forward Send OnComButtonClick llItem llColIndex llKey
Showln "ButtonClick" llItem llKey
End_Procedure
// Fired after cell's state has been changed.
Procedure OnComCellStateChanged HITEM llItem Integer llColIndex
Forward Send OnComCellStateChanged llItem llColIndex
Showln "CellStateChanged" llItem
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComColumnAutoResize to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComAllowSizing of hoColumn to False
Set ComWidth of hoColumn to 32
Set ComFormatColumn of hoColumn to "1 index ``"
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComAdd of hoColumns1 "Def" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComAllowSizing of hoColumn1 to False
Set ComWidth of hoColumn1 to 48
Set ComFormatColumn of hoColumn1 to "` `"
Set ComDef of hoColumn1 OLEexCellHasCheckBox to True
Set ComDef of hoColumn1 OLEexCellHasButton to True
Set ComDef of hoColumn1 OLEexCellButtonAutoWidth to True
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Variant voColumns2
Get ComColumns to voColumns2
Handle hoColumns2
Get Create (RefClass(cComColumns)) to hoColumns2
Set pvComObject of hoColumns2 to voColumns2
Get ComAdd of hoColumns2 "" to Nothing
Send Destroy to hoColumns2
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Get ComAddItem of hoItems "" to Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1815
|
Does filtering work with umlauts / accents characters
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Names" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComDisplayFilterButton of hoColumn to True
Set ComFilterType of hoColumn to OLEexPattern
Send Destroy to hoColumn
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Get ComAddItem of hoItems "Mantel" to Nothing
Get ComAddItem of hoItems "Mechanik" to Nothing
Get ComAddItem of hoItems "Motor" to Nothing
Get ComAddItem of hoItems "Murks" to Nothing
Get ComAddItem of hoItems "Märchen" to Nothing
Get ComAddItem of hoItems "Möhren" to Nothing
Get ComAddItem of hoItems "Mühle" to Nothing
Get ComAddItem of hoItems "Sérigraphie" to Nothing
Send Destroy to hoItems
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComItem of hoColumns1 0 to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComFilter of hoColumn1 to "*ä*"
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Send ComApplyFilter
Send ComEndUpdate
End_Procedure
|
|
1814
|
How can I temporarily disable resizing the overview part of the control
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComBackColorLevelHeader to (ComBackColor(Self))
Set ComOnResizeControl to OLEexDisableOverview
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComOverviewVisible of hoChart to (OLEexOverviewSplitter + OLEexOverviewShowDateTimeScale + OLEexOverviewAllowVerticalScroll + OLEexOverviewShowAllVisible)
Set ComOverviewHeight of hoChart to 32
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 1")) "Task" "1/2/2001" "1/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 2")) "Task" "2/2/2001" "2/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 3")) "Task" "3/2/2001" "3/11/2001" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1813
|
Is it possible to resize the overview part of the control at runtime
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABVADg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGUYBRgmFgAQhFcZQSBcEgTDaMYzgMBYJhEMQyDSAUIjPEyMg0DjIIwgJIUaw0GSXIRkGQZChGJooTJQMrTZIEbQxHSkIyRVTmZACS5NRZPYy0FAkQhlFSbJBCOKwVomR5KUxTVg1DJwahLCKULLhGI7KgObIRSJOcZ1XAdCQ0cB0XpAC6LaqSA4nSjKcqwJKEZRJIyjJwgSrrWhePoJYBVAAQPQdDYaCivK5uWK6PqKUIlZBQGQVNS1MRrLSEcwgPKgAyzDadZzfQAWTZFTQjN61RgtXR6eyoAJ0aziFDVFo0WRlEwacorGhcbgPPrCRrxGBVNwgGOJo4kIeASB0Zw/iGDoym6dobh2XpiDWJo5HMd56h6dxjlICIEhQDQmDOIZUmQZZlAADpYHIEQ3nUGgNhCEIhAkawamAAAYEWRAGB2bA2EqYg2AyA4glgPgSgQYRIEIFoEmEeBWBiBphFAAgPDwDgDEycQ4A0Q5IwkDwjgyWA8k4SIsmUNoPEOFJbD0DhjHINA3E8Q4eDiDojhiYJmg+Ixokic4LmKQxiCkNk2CCX4DmGaA0nAN4NBiDJSDwTgTEycg4E0WIYlcPJiiiMJZhCTYpgCcw5g2OYOGWGQmCkEJkheYopGoVw1GSGQuA2ExIlOQJcDOZJzEDSJNBiAgiU4Q5GCeChNHkHJygsaBzGaCYimiCY0mMNZoCMWhUDUJ5pkYTIDk6YxwkwO5NlMOoch6JQJm4U4JCIMxWFSKbCBoKIgmJDAuDgKhohKIoTk0GhaHOJgNiMKJuDaaYzHCTYnAyaZmjSKIiDiCghjEYg6AaR4yk0OpOiFSQLAKNgjGcQ40lkMhOmqZo7DKTpzG6Pw3CmYx2HiNAsCqBh8h6Z5bh6T4oC0G4Im+OAtlMNpTjUTYDCKVo2C3QBLi6a5bH6YY4EyehzAGO4wEwDoejwK5rnK95vDgPJsDWTBjjSWAxnEK5aleNhriuawKi8Lp7H8HpHHGXBskyQpxguXwNgMTpDFiRZDnEExfBSPRvHuXwYkycYslae5NjMQwrDGNZxFyHINDsDRTBMKZKnKLIwm2S4xF0Jw8lKTIcm9eA0hyQwuksM5jiyVQwnQDQIlaVo0EyLwQlGcRNCME5EjKfYXGSWEhDMQ5QnOahHG6KwoFOCoFiOaBNlcdIjiQag7HOL0dwuxKC1aeNQI4BQihNDoEwXowxmh8CIL8Yg8ROBfASMcaIOR6CHBkMgLgrwUjLHkHMG4NQaBzE4MQaIyw5gxEsH0Dw9FBBNA6PUDoLwpjTHqF0N4WQShSHgGwcY2RkhdFCL8bYdwOivDqNse4fRnh5G+PYEgaR1B0E4B4D4ixxB4G8E8SI5R8D+DeJUc4eRPB/EaJ8DwpwojDHUPofwtxYjtH2F4d4sx3j7E+AcXo8B9geFCNYOIHhfg/GmPQPoXw3jZHuPoX4hxuj1H8J8T43RPhDEgM8eo/B/iQGuPwfxEh1guAIAwQAgCAg" to Nothing
Send Destroy to hoAppearance
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComOverviewVisible of hoChart to (OLEexOverviewSplitter + OLEexOverviewShowDateTimeScale + OLEexOverviewAllowVerticalScroll + OLEexOverviewShowAllVisible)
Set ComOverviewHeight of hoChart to 32
Set ComOverviewSelBackColor of hoChart to |CI$1000000
Set ComOverviewBackColor of hoChart to (RGB(250,250,250))
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 1")) "Task" "1/2/2001" "1/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 2")) "Task" "2/2/2001" "2/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 3")) "Task" "3/2/2001" "3/11/2001" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1812
|
You've provided examples of how to create bars for each record of a MS Access table, however I would like to create a database connected Gantt that has multiple bars per item/resource. Could you please advise
// Occurs after a new Group Item has been inserted to Items collection.
Procedure OnComAddGroupItem HITEM llItem
Forward Send OnComAddGroupItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems llItem "Summary" (ComCellValue(hoItems,llItem,2)) (ComCellValue(hoItems,llItem,4)) "0" Nothing
Send ComDefineSummaryBars of hoItems llItem "0" -3 "0"
Send ComAddBar of hoItems llItem "SummaryB" (ComCellValue(hoItems,llItem,2)) (ComCellValue(hoItems,llItem,4)) "1" Nothing
Send ComDefineSummaryBars of hoItems llItem "1" -3 "1"
Set ComItemBackColor of hoItems llItem to (RGB(240,240,240))
Send Destroy to hoItems
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComItemBackColor of hoChart llItem to (RGB(240,240,240))
Send Destroy to hoChart
End_Procedure
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Send ComAddBar of hoItems1 llItem "Task" (ComCellValue(hoItems1,llItem,2)) (ComCellValue(hoItems1,llItem,4)) (ComItemBar(hoItems1,llItem,"",OLEexBarsCount)) Nothing
Send ComAddBar of hoItems1 llItem "TaskB" (ComCellValue(hoItems1,llItem,3)) (ComCellValue(hoItems1,llItem,4)) (ComItemBar(hoItems1,llItem,"",OLEexBarsCount)) Nothing
Send Destroy to hoItems1
End_Procedure
// Occurs when the user presses a mouse button.
Procedure OnComMouseDown Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComMouseDown llButton llShift llX llY
Variant i
Get ComItemFromPoint -1 -1 c hit to i
Variant v
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComItem of hoColumns c to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Get ComData of hoColumn to v
Send Destroy to hoColumn
Send Destroy to hoColumns
Set ComFullRowSelect to v
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to True
Set ComHeaderHeight to 22
Set ComHeaderAppearance to OLEFlat
Set ComBackColorLock to (RGB(240,240,240))
Set ComBackColorHeader to (ComBackColorLock(Self))
Set ComHasLines to OLEexNoLine
Set ComColumnAutoResize to False
Set ComSortBarVisible to False
Set ComAllowGroupBy to True
Set ComReadOnly to OLEexReadOnly
Set ComShowFocusRect to False
Set ComCountLockedColumns to 1
Set ComAutoDrag to OLEexAutoDragScroll
Set ComSingleSort to False
Set ComColumnsAllowSizing to True
Set ComDrawGridLines to OLEexAllLines
Set ComGridLineStyle to OLEexGridLinesSolid
Set ComGridLineColor to (RGB(220,220,220))
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Set ComFirstVisibleDate of hoChart1 to "9/1/1994"
Set ComLevelCount of hoChart1 to 2
Set ComPaneWidth of hoChart1 False to 256
Variant voBars
Get ComBars of hoChart1 to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Task" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHeight of hoBar to 15
Set ComColor of hoBar to (RGB(128,128,128))
Set ComStartColor of hoBar to (RGB(204,204,0))
Set ComEndColor of hoBar to (ComStartColor(hoBar))
Set ComOverlaidType of hoBar to OLEexOverlaidBarsStack
Set ComOverlaidGroup of hoBar to "Task,TaskB"
Set ComPattern of hoBar to (OLEexPatternGradientVBox + OLEexPatternBox)
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart1 to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComCopy of hoBars1 "Task" "TaskB" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComColor of hoBar1 to (RGB(128,128,128))
Set ComStartColor of hoBar1 to (RGB(153,153,0))
Set ComEndColor of hoBar1 to (ComStartColor(hoBar1))
Send Destroy to hoBar1
Send Destroy to hoBars1
Variant voBars2
Get ComBars of hoChart1 to voBars2
Handle hoBars2
Get Create (RefClass(cComBars)) to hoBars2
Set pvComObject of hoBars2 to voBars2
Variant voBar2
Get ComItem of hoBars2 "Summary" to voBar2
Handle hoBar2
Get Create (RefClass(cComBar)) to hoBar2
Set pvComObject of hoBar2 to voBar2
Set ComOverlaidType of hoBar2 to OLEexOverlaidBarsStack
Set ComOverlaidGroup of hoBar2 to "Summary,SummaryB"
Set ComColor of hoBar2 to (RGB(204,204,0))
Set ComStartColor of hoBar2 to (ComColor(hoBar2))
Set ComEndColor of hoBar2 to (ComColor(hoBar2))
Send Destroy to hoBar2
Send Destroy to hoBars2
Variant voBars3
Get ComBars of hoChart1 to voBars3
Handle hoBars3
Get Create (RefClass(cComBars)) to hoBars3
Set pvComObject of hoBars3 to voBars3
Variant voBar3
Get ComCopy of hoBars3 "Summary" "SummaryB" to voBar3
Handle hoBar3
Get Create (RefClass(cComBar)) to hoBar3
Set pvComObject of hoBar3 to voBar3
Set ComColor of hoBar3 to (RGB(153,153,0))
Set ComStartColor of hoBar3 to (ComColor(hoBar3))
Set ComEndColor of hoBar3 to (ComColor(hoBar3))
Send Destroy to hoBar3
Send Destroy to hoBars3
Send Destroy to hoChart1
Set ComBackColorSortBar to (ComBackColor(Self))
Set ComColumnAutoResize to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "Orders" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenStatic OLEadLockOptimistic Nothing
Set ComDataSource to rs
Set ComDebug to True
Variant voColumns1
Get ComColumns to voColumns1
Handle hoColumns1
Get Create (RefClass(cComColumns)) to hoColumns1
Set pvComObject of hoColumns1 to voColumns1
Variant voColumn1
Get ComItem of hoColumns1 0 to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComData of hoColumn1 to -1
Send Destroy to hoColumn1
Send Destroy to hoColumns1
Set ComLayout to "singlesort="C5:1";multiplesort=" C1:2""
Send ComEndUpdate
End_Procedure
|
|
1811
|
How can I filter for multiple captions on a single column, using OR clause
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComColumnAutoResize to True
Set ComContinueColumnScroll to False
Set ComMarkSearchColumn to True
Set ComSearchColumnIndex to 1
Set ComFilterBarPromptVisible to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Name" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComWidth of hoColumn to 96
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "Title" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComWidth of hoColumn1 to 96
Send Destroy to hoColumn1
Get ComAdd of hoColumns "City" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h0
Get ComAddItem of hoItems "Nancy Davolio" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Seattle"
Get ComAddItem of hoItems "Andrew Fuller" to h0
Set ComCellValue of hoItems h0 1 to "Vice President, Sales"
Set ComCellValue of hoItems h0 2 to "Tacoma"
Set ComSelectItem of hoItems h0 to True
Get ComAddItem of hoItems "Janet Leverling" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Kirkland"
Get ComAddItem of hoItems "Margaret Peacock" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Redmond"
Get ComAddItem of hoItems "Steven Buchanan" to h0
Set ComCellValue of hoItems h0 1 to "Sales Manager"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Michael Suyama" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Robert King" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Laura Callahan" to h0
Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator"
Set ComCellValue of hoItems h0 2 to "Seattle"
Get ComAddItem of hoItems "Anne Dodsworth" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Send Destroy to hoItems
Set ComFilterBarPromptColumns to "1"
Set ComFilterBarPromptPattern to "Vice Inside"
Set ComFilterBarPromptType to OLEexFilterPromptContainsAny
Send ComEndUpdate
End_Procedure
|
|
1810
|
How can I filter for multiple captions on a single column, using AND clause
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComColumnAutoResize to True
Set ComContinueColumnScroll to False
Set ComMarkSearchColumn to True
Set ComSearchColumnIndex to 1
Set ComFilterBarPromptVisible to True
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Name" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComWidth of hoColumn to 96
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "Title" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComWidth of hoColumn1 to 96
Send Destroy to hoColumn1
Get ComAdd of hoColumns "City" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h0
Get ComAddItem of hoItems "Nancy Davolio" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Seattle"
Get ComAddItem of hoItems "Andrew Fuller" to h0
Set ComCellValue of hoItems h0 1 to "Vice President, Sales"
Set ComCellValue of hoItems h0 2 to "Tacoma"
Set ComSelectItem of hoItems h0 to True
Get ComAddItem of hoItems "Janet Leverling" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Kirkland"
Get ComAddItem of hoItems "Margaret Peacock" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Redmond"
Get ComAddItem of hoItems "Steven Buchanan" to h0
Set ComCellValue of hoItems h0 1 to "Sales Manager"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Michael Suyama" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Robert King" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Laura Callahan" to h0
Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator"
Set ComCellValue of hoItems h0 2 to "Seattle"
Get ComAddItem of hoItems "Anne Dodsworth" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Send Destroy to hoItems
Set ComFilterBarPromptColumns to "1"
Set ComFilterBarPromptPattern to "Vice Sales"
Set ComFilterBarPromptType to OLEexFilterPromptContainsAll
Send ComEndUpdate
End_Procedure
|
|
1809
|
How can I display the limits/margins of the project, in the overview part of the control
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABVADg6AADACAxSDEMQBQKAAzQFAYbhgHCGAAGUYBRgmFgAQhFcZQSBcEgTDaMYzgMBYJhEMQyDSAUIjPEyMg0DjIIwgJIUaw0GSXIRkGQZChGJooTJQMrTZIEbQxHSkIyRVTmZACS5NRZPYy0FAkQhlFSbJBCOKwVomR5KUxTVg1DJwahLCKULLhGI7KgObIRSJOcZ1XAdCQ0cB0XpAC6LaqSA4nSjKcqwJKEZRJIyjJwgSrrWhePoJYBVAAQPQdDYaCivK5uWK6PqKUIlZBQGQVNS1MRrLSEcwgPKgAyzDadZzfQAWTZFTQjN61RgtXR6eyoAJ0aziFDVFo0WRlEwacorGhcbgPPrCRrxGBVNwgGOJo4kIeASB0Zw/iGDoym6dobh2XpiDWJo5HMd56h6dxjlICIEhQDQmDOIZUmQZZlAADpYHIEQ3nUGgNhCEIhAkawamAAAYEWRAGB2bA2EqYg2AyA4glgPgSgQYRIEIFoEmEeBWBiBphFAAgPDwDgDEycQ4A0Q5IwkDwjgyWA8k4SIsmUNoPEOFJbD0DhjHINA3E8Q4eDiDojhiYJmg+Ixokic4LmKQxiCkNk2CCX4DmGaA0nAN4NBiDJSDwTgTEycg4E0WIYlcPJiiiMJZhCTYpgCcw5g2OYOGWGQmCkEJkheYopGoVw1GSGQuA2ExIlOQJcDOZJzEDSJNBiAgiU4Q5GCeChNHkHJygsaBzGaCYimiCY0mMNZoCMWhUDUJ5pkYTIDk6YxwkwO5NlMOoch6JQJm4U4JCIMxWFSKbCBoKIgmJDAuDgKhohKIoTk0GhaHOJgNiMKJuDaaYzHCTYnAyaZmjSKIiDiCghjEYg6AaR4yk0OpOiFSQLAKNgjGcQ40lkMhOmqZo7DKTpzG6Pw3CmYx2HiNAsCqBh8h6Z5bh6T4oC0G4Im+OAtlMNpTjUTYDCKVo2C3QBLi6a5bH6YY4EyehzAGO4wEwDoejwK5rnK95vDgPJsDWTBjjSWAxnEK5aleNhriuawKi8Lp7H8HpHHGXBskyQpxguXwNgMTpDFiRZDnEExfBSPRvHuXwYkycYslae5NjMQwrDGNZxFyHINDsDRTBMKZKnKLIwm2S4xF0Jw8lKTIcm9eA0hyQwuksM5jiyVQwnQDQIlaVo0EyLwQlGcRNCME5EjKfYXGSWEhDMQ5QnOahHG6KwoFOCoFiOaBNlcdIjiQag7HOL0dwuxKC1aeNQI4BQihNDoEwXowxmh8CIL8Yg8ROBfASMcaIOR6CHBkMgLgrwUjLHkHMG4NQaBzE4MQaIyw5gxEsH0Dw9FBBNA6PUDoLwpjTHqF0N4WQShSHgGwcY2RkhdFCL8bYdwOivDqNse4fRnh5G+PYEgaR1B0E4B4D4ixxB4G8E8SI5R8D+DeJUc4eRPB/EaJ8DwpwojDHUPofwtxYjtH2F4d4sx3j7E+AcXo8B9geFCNYOIHhfg/GmPQPoXw3jZHuPoX4hxuj1H8J8T43RPhDEgM8eo/B/iQGuPwfxEh1guAIAwQAgCAg" to Nothing
Send Destroy to hoAppearance
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComOverviewVisible of hoChart to (|CI$400 + OLEexOverviewShowSelMargins + OLEexOverviewShowMargins + OLEexOverviewShowDateTimeScaleBottom + OLEexOverviewShowAllVisible)
Set ComOverviewHeight of hoChart to 64
Set ComOverviewSelBackColor of hoChart to |CI$1000000
Set ComOverviewBackColor of hoChart to (RGB(250,250,250))
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 1")) "Task" "1/2/2001" "1/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 2")) "Task" "2/2/2001" "2/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 3")) "Task" "3/2/2001" "3/11/2001" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1808
|
Is it possible to display a time-scale for the overview part of the control (separated)
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComOverviewVisible of hoChart to (OLEexOverviewShowDateTimeScaleSplit + OLEexOverviewShowAllVisible)
Set ComOverviewHeight of hoChart to 48
Set ComLevelCount of hoChart to 2
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 1")) "Task" "1/2/2001" "1/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 2")) "Task" "2/2/2001" "2/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 3")) "Task" "3/2/2001" "3/11/2001" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1807
|
Is it possible to display a time-scale for the overview part of the control
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComOverviewVisible of hoChart to (OLEexOverviewShowDateTimeScale + OLEexOverviewShowAllVisible)
Set ComLevelCount of hoChart to 2
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 1")) "Task" "1/2/2001" "1/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 2")) "Task" "2/2/2001" "2/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 3")) "Task" "3/2/2001" "3/11/2001" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1806
|
How can I display the time-scale only, in the overview part of the control
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComBackColorLevelHeader to (ComBackColor(Self))
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComPaneWidth of hoChart False to 48
Set ComOverviewVisible of hoChart to (OLEexOverviewShowDateTimeScale + OLEexOverviewHideBars + OLEexOverviewShowAllVisible)
Set ComLevelCount of hoChart to 2
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Column" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 1")) "Task" "1/2/2001" "1/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 2")) "Task" "2/2/2001" "2/11/2001" Nothing Nothing
Send ComAddBar of hoItems (ComAddItem(hoItems,"Item 3")) "Task" "3/2/2001" "3/11/2001" Nothing Nothing
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1805
|
How can I detect that the mouse pointer is within an InsideZoom object
// Occurs when the user moves the mouse.
Procedure OnComMouseMove Short llButton Short llShift OLE_XPOS_PIXELS llX OLE_YPOS_PIXELS llY
Forward Send OnComMouseMove llButton llShift llX llY
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Variant d
Get ComDateFromPoint of hoChart -1 -1 to d
Variant v
Variant voInsideZooms
Get ComInsideZooms of hoChart to voInsideZooms
Handle hoInsideZooms
Get Create (RefClass(cComInsideZooms)) to hoInsideZooms
Set pvComObject of hoInsideZooms to voInsideZooms
Get ComContains of hoInsideZooms d to v
Send Destroy to hoInsideZooms
Variant iz
Move v to iz
Showln d "If the iz object is nothing, the date is not zoomed, else it is." iz
Send Destroy to hoChart
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart1
Get ComChart to voChart1
Handle hoChart1
Get Create (RefClass(cComChart)) to hoChart1
Set pvComObject of hoChart1 to voChart1
Set ComFirstVisibleDate of hoChart1 to "1/1/2001"
Set ComPaneWidth of hoChart1 False to 0
Set ComLevelCount of hoChart1 to 2
Set ComFirstWeekDay of hoChart1 to OLEexMonday
Set ComAllowInsideZoom of hoChart1 to True
Variant voInsideZooms1
Get ComInsideZooms of hoChart1 to voInsideZooms1
Handle hoInsideZooms1
Get Create (RefClass(cComInsideZooms)) to hoInsideZooms1
Set pvComObject of hoInsideZooms1 to voInsideZooms1
Get ComAdd of hoInsideZooms1 "1/10/2001" to Nothing
Send Destroy to hoInsideZooms1
Send Destroy to hoChart1
Send ComEndUpdate
End_Procedure
|
|
1804
|
Is it possible to word-wrap text/caption on the bar, so it gets displayed on multiple lines
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComScrollBySingleLine to True
Set ComItemsAllowSizing to OLEexResizeItem
Set ComDrawGridLines to OLEexHLines
Set ComHeaderHeight to 28
Set ComDefaultItemHeight to 24
Set ComBackColorLevelHeader to (ComBackColor(Self))
Set ComHeaderAppearance to OLEBump
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Tasks" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComLevelCount of hoChart to 2
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Set ComDrawGridLines of hoChart to OLEexHLines
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComCopy of hoBars "Task" "TaskB" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComHeight of hoBar to 15
Set ComPattern of hoBar to OLEexPatternBox
Set ComStartColor of hoBar to (RGB(204,232,255))
Set ComEndColor of hoBar to (ComStartColor(hoBar))
Set ComColor of hoBar to (RGB(0,0,255))
Send Destroy to hoBar
Send Destroy to hoBars
Variant voBars1
Get ComBars of hoChart to voBars1
Handle hoBars1
Get Create (RefClass(cComBars)) to hoBars1
Set pvComObject of hoBars1 to voBars1
Variant voBar1
Get ComItem of hoBars1 "Task" to voBar1
Handle hoBar1
Get Create (RefClass(cComBar)) to hoBar1
Set pvComObject of hoBar1 to voBar1
Set ComHeight of hoBar1 to -1
Set ComPattern of hoBar1 to OLEexPatternBox
Set ComStartColor of hoBar1 to (RGB(204,232,255))
Set ComEndColor of hoBar1 to (ComStartColor(hoBar1))
Set ComColor of hoBar1 to (RGB(0,0,255))
Send Destroy to hoBar1
Send Destroy to hoBars1
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h
Get ComAddItem of hoItems "Word-Wrap Inside" to h
Send ComAddBar of hoItems h "Task" "1/9/2001" "1/13/2001" "A1" Nothing
Set ComItemBar of hoItems h "A1" OLEexBarBackgroundExt to "none[(2,2,100%-4,100%-4),text=`This is a bit of text that should break the line`,wordwrap]"
Get ComAddItem of hoItems "Word-Wrap Inside" to h
Send ComAddBar of hoItems h "Task" "1/5/2001" "1/19/2001" "A2" Nothing
Set ComItemBar of hoItems h "A2" OLEexBarBackgroundExt to "none[(2,2,100%-4,100%-4),align=0x11,text=`This is a bit of text that should break the line`,wordwrap]"
Get ComAddItem of hoItems "Word-Wrap Back" to h
Send ComAddBar of hoItems h "TaskB" "1/9/2001" "1/13/2001" "A3" Nothing
Set ComItemBar of hoItems h "A3" OLEexBarBackgroundExt to "client[align=0x11,text=`This is a bit of text that should break the line`,wordwrap]"
Set ComItemBar of hoItems h "A3" OLEexBarBackgroundExtFlags to 2
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|
|
1803
|
Can I set the search box / filterbarprompt to invisible, so I can use my own input and *string* via VBA
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Set ComColumnAutoResize to True
Set ComContinueColumnScroll to False
Set ComMarkSearchColumn to False
Set ComSearchColumnIndex to 1
Set ComFilterBarHeight to 0
Set ComFilterBarPromptVisible to True
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Variant voColumn
Get ComAdd of hoColumns "Name" to voColumn
Handle hoColumn
Get Create (RefClass(cComColumn)) to hoColumn
Set pvComObject of hoColumn to voColumn
Set ComWidth of hoColumn to 96
Send Destroy to hoColumn
Variant voColumn1
Get ComAdd of hoColumns "Title" to voColumn1
Handle hoColumn1
Get Create (RefClass(cComColumn)) to hoColumn1
Set pvComObject of hoColumn1 to voColumn1
Set ComWidth of hoColumn1 to 96
Send Destroy to hoColumn1
Get ComAdd of hoColumns "City" to Nothing
Send Destroy to hoColumns
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant h0
Get ComAddItem of hoItems "Nancy Davolio" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Seattle"
Get ComAddItem of hoItems "Andrew Fuller" to h0
Set ComCellValue of hoItems h0 1 to "Vice President, Sales"
Set ComCellValue of hoItems h0 2 to "Tacoma"
Set ComSelectItem of hoItems h0 to True
Get ComAddItem of hoItems "Janet Leverling" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Kirkland"
Get ComAddItem of hoItems "Margaret Peacock" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "Redmond"
Get ComAddItem of hoItems "Steven Buchanan" to h0
Set ComCellValue of hoItems h0 1 to "Sales Manager"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Michael Suyama" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Robert King" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Get ComAddItem of hoItems "Laura Callahan" to h0
Set ComCellValue of hoItems h0 1 to "Inside Sales Coordinator"
Set ComCellValue of hoItems h0 2 to "Seattle"
Get ComAddItem of hoItems "Anne Dodsworth" to h0
Set ComCellValue of hoItems h0 1 to "Sales Representative"
Set ComCellValue of hoItems h0 2 to "London"
Send Destroy to hoItems
Set ComFilterBarPromptPattern to "London"
Send ComEndUpdate
End_Procedure
|
|
1802
|
How to load a hierarchy using the control's DataSource property (Parent-ID-Relation)
// Occurs after a new Item has been inserted to Items collection.
Procedure OnComAddItem HITEM llItem
Forward Send OnComAddItem llItem
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Send ComSetParent of hoItems llItem (ComFindItem(hoItems,(ComCellValue(hoItems,llItem,"ReportsTo")),"EmployeeID",Nothing))
Send Destroy to hoItems
End_Procedure
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart True to 0
Send Destroy to hoChart
Set ComLinesAtRoot to OLEexLinesAtRoot
Set ComColumnAutoResize to False
Set ComContinueColumnScroll to False
Variant rs
Get Comcreateobject "ADOR.Recordset" to rs
Send ComOpen "SELECT * FROM Employees ORDER BY ReportsTo" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb" OLEadOpenStatic OLEadLockOptimistic Nothing
Set ComDataSource to rs
Variant voItems1
Get ComItems to voItems1
Handle hoItems1
Get Create (RefClass(cComItems)) to hoItems1
Set pvComObject of hoItems1 to voItems1
Set ComExpandItem of hoItems1 0 to True
Send Destroy to hoItems1
Send ComEndUpdate
End_Procedure
|
|
1801
|
How can I highlight the limits/margins of a summary bar, according with the child bars
Procedure OnCreate
Forward Send OnCreate
Send ComBeginUpdate
Variant voAppearance
Get ComVisualAppearance to voAppearance
Handle hoAppearance
Get Create (RefClass(cComAppearance)) to hoAppearance
Set pvComObject of hoAppearance to voAppearance
Get ComAdd of hoAppearance 1 "gBFLBCJwBAEHhEJAAEhABRkIQAAYAQGKQYhiAKBQAGaAoDDcMA4QwAAyjhwkAIIQK/cZRPC0Ow8GSEZAgOKIch6FgCQjEIxDKIsVRZEiDYRmGLpIiOJoWSQBUIyJKoAQ0f6fIziaTpNiGL4yTBPMzyJRcEx1GyBZ5negaAo2AwIQiUBomGahajkMqZQAJaCSCI2Y4eDZCIoTXR1WAxDq3ZruKpLUpOc4DOrEMIwCEBA=" to Nothing
Get ComAdd of hoAppearance 2 "CP:1 -4 0 5 0" to Nothing
Get ComAdd of hoAppearance 3 "gBFLBCJwBAEHhEJAAEhABOMGACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGUYBRgmFgAQhFcZQSKUOQTDKMIziYBYJhEMQyDAAUIjOKsIhkGYcZAGQBJCjWGodQRHc5TNCMTRRECDY4kAYpAiKRYbSpAcyQHQ8bQtHwYKAoOg6JjWIAHRqCMI0XINHQ3FwaRJsCwoJhOZIDWZENDQTSsLSxJSkIRfe4wArNf4XVBVMqSdKEZRJLybJwADApAo2eIlQjJdQ4TSdBSdQwDLYhECpbwCT6JT7jGLQJZsNyvBLIYDrKA8UozFqHQRYNhxDZNShhM6rMigPQQAq8AKlRbVNzXLamLwHRS9BpoORhUjHD4bVxVOyaPpAAaBFbhI44QZOHYNYfjgaI0BySp8HMVZdlgaxtBqexWkqOw1lGbZzlwfQ0AwYR/gka5FiMGpgkQYYviGV4kBUWpmlsaYGHMEgACECQUAaEYMHQHRHCGFRBECRJkGQQgTGCVBoDYQhCgQJZoG4EIAGEFwGB+dwxHaB5iAabReggYhGnUToJGIRgCCiCBdjiNguGmYo4gIKoMGIKIeDSCYTGiXg4EITo3hAiJAICA==" to Nothing
Send Destroy to hoAppearance
Variant voColumns
Get ComColumns to voColumns
Handle hoColumns
Get Create (RefClass(cComColumns)) to hoColumns
Set pvComObject of hoColumns to voColumns
Get ComAdd of hoColumns "Task" to Nothing
Send Destroy to hoColumns
Variant voChart
Get ComChart to voChart
Handle hoChart
Get Create (RefClass(cComChart)) to hoChart
Set pvComObject of hoChart to voChart
Set ComPaneWidth of hoChart False to 128
Set ComFirstVisibleDate of hoChart to "1/1/2001"
Variant voBars
Get ComBars of hoChart to voBars
Handle hoBars
Get Create (RefClass(cComBars)) to hoBars
Set pvComObject of hoBars to voBars
Variant voBar
Get ComItem of hoBars "Summary" to voBar
Handle hoBar
Get Create (RefClass(cComBar)) to hoBar
Set pvComObject of hoBar to voBar
Set ComColor of hoBar to |CI$3000000
Send Destroy to hoBar
Send Destroy to hoBars
Send Destroy to hoChart
Variant voItems
Get ComItems to voItems
Handle hoItems
Get Create (RefClass(cComItems)) to hoItems
Set pvComObject of hoItems to voItems
Variant hSummary
Get ComAddItem of hoItems "Summary" to hSummary
Send ComAddBar of hoItems hSummary "Summary" "1/2/2001" "1/2/2001" "" Nothing
Variant hTask
Get ComInsertItem of hoItems hSummary "Task A" to hTask
Send ComAddBar of hoItems hTask "Task" "1/2/2001" "1/5/2001" "K1" Nothing
Get ComInsertItem of hoItems hSummary "Task B" to hTask
Send ComAddBar of hoItems hTask "Task" "1/4/2001" "1/8/2001" "K2" Nothing
Get ComInsertItem of hoItems hSummary "Task C" to hTask
Send ComAddBar of hoItems hTask "Task" "1/6/2001" "1/10/2001" "K3" Nothing
Set ComExpandItem of hoItems hSummary to True
Send ComDefineSummaryBars of hoItems hSummary "" -1 "<*>"
Set ComItemBar of hoItems hSummary "" OLEexSummaryBarBackColor to 33554432
Send Destroy to hoItems
Send ComEndUpdate
End_Procedure
|